How to get the data from database in node.js?

Question

I want to get the data from database. I tried like this but what happening here is that, I am getting the total number rows. But I want the total data. Can any one help me?

connection.on('connect',function(err){
 if(err){
      console.log(err)
 }else{
 var sql = "SELECT * FROM xxxxx";
   var request = new Request(sql,
   function(err,result){
       if(err){
           console.log(err);
       }else{
           console.log("hello:"+result)
       }
   });
   connection.execSql(request);
 } 
 });

I need the total data from database.

which library do you use? connection.execSql

Jinceon
– Jinceon

2015-06-16 10:39:14 +00:00
Commented Jun 16, 2015 at 10:39 — Jinceon
– Jinceon, Commented Jun 16, 2015 at 10:39

Beto López · Accepted Answer · 2015-06-17 11:44:16Z

2

You can do it, using pool, like this:

var mysql      = require('mysql');
var pool = mysql.createPool({
    host     : 'localhost',
    user     : 'mysql username',
    password : 'password',
    database: 'database_name'
});

pool.getConnection(function(err, connection) {
    connection.query('SELECT * FROM table',function(err,rows){
        if (err) console.log('error!: '+err);
        else console.log(rows);
    } );        
connection.release();
// Don't use the connection here, it has been returned to the pool.
});

Hope it helps

edited Jun 17, 2015 at 11:44

answered Jun 16, 2015 at 10:43

Beto López

916 bronze badges

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

Collectives™ on Stack Overflow

How to get the data from database in node.js?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related