unable to connect to database in nodejs?

Question

I am reading this and tried to connect to MYSQL database using node js.Here is my program

var mysql =  require('mysql');
var connection =  mysql.createConnection({
host : "localhost",
    User : "root",
password: ""
 });
connection.connect();
connection.query("use test");
var strQuery = "select * from chat";    

connection.query( strQuery, function(err, rows){
if(err) {
    throw err;
}else{
    console.log( rows );
}
 })
  connection.destroy( );

I an not getting any error but also unable to get any output

@Quentin I have changed quotes but I am not getting any error but also not getting output as well — Fresher
– Fresher, Commented May 6, 2014 at 10:11
I voted too fast to close, there is another blocking problem. — Denys Séguret
– Denys Séguret, Commented May 6, 2014 at 10:16

Denys Séguret · Accepted Answer · 2014-05-08 17:57:27Z

2

In order to have the program wait for your queries to be executed, replace

connection.destroy();

with

connection.end();

edited May 8, 2014 at 17:57

answered May 6, 2014 at 10:04

Denys Séguret

384k90 gold badges813 silver badges780 bronze badges

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

5 Comments

Fresher Over a year ago

I have used standard quotes but now I am not getting output

Denys Séguret Over a year ago

Well. Change your standard and use the same quotes as other developers.

Fresher Over a year ago

I am not getting any error but also not getting output as well

Fresher Over a year ago

but it is giving output as [ { chat_name: 'John' } ].Could you tell me how to get just john from here

Ivo Pereira Over a year ago

@Fresher try console.log( rows[0].chat_name );

Collectives™ on Stack Overflow

unable to connect to database in nodejs?

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related