NodeJS Mysql count query for record check

Question

I have been using felixge/node-mysql with NodeJS to connect MySQL !

Following query not executing and not throwing any error also.

var mysql = require('mysql');

client.query('USE userrecorddetails');


client.query(
  'select count(1) as cnt as userstatus where id = 2353',
  function (err, results, fields) {
    if (err) {
      throw err;
    }
})

Note : the above query have zero records for that id 2353.

If any record is available, then i can able to get the output from the above query.

Please any help on this.

do yo mean that callback function is not called at all?

Andrey Sidorov
– Andrey Sidorov

2011-10-12 10:40:49 +00:00
Commented Oct 12, 2011 at 10:40 — Andrey Sidorov
– Andrey Sidorov, Commented Oct 12, 2011 at 10:40
Correct! The callback function is not called!

Raja
– Raja

2011-10-12 11:01:23 +00:00
Commented Oct 12, 2011 at 11:01 — Raja
– Raja, Commented Oct 12, 2011 at 11:01

Andrey Sidorov · Accepted Answer · 2011-10-12 12:49:33Z

2

I can't confirm your problem 1) original query contains errors 2) output from following example (no records with id=2352)

var client = require('mysql').createClient();
client.query('USE test');

client.query(
  //'select count(1) as cnt as userstatus where id = 2353',
  'select count(1) as cnt from userstatus where id = 2353',
  function (err, results, fields) {
    if (err) {
      console.log(err);
      throw err;
    }
    console.log(results, fields);
})

is

[ { cnt: 0 } ] { cnt: 
   { length: 25,
     received: 25,
     number: 2,
     type: 4,
     catalog: 'def',
     name: 'cnt',
     charsetNumber: 63,
     fieldLength: 21,
     fieldType: 8,
     flags: 129,
     decimals: 0 } }

answered Oct 12, 2011 at 12:49

Andrey Sidorov

25.6k5 gold badges65 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Raja Over a year ago

Thanks. The query that i was posted is wrong. But in my code it is correct. Problem i was found that i am using 'client.end();' after the query. It is terminating mysql connection and does not go inside to the callback function.

Collectives™ on Stack Overflow

NodeJS Mysql count query for record check

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related