Create an object with mysql query

Question

I can console.log the object that I want, but how can I retrieve the object outside of connection.query()?

var express = require('express');
var mysql = require("mysql");

var app = express();

var connection = mysql.createPool({
  connectionLimit: 50,
  host: "localhost",
  user: "root",
  password: "",
  database: "sakila"
});

app.get('/', function(req, res){
  connection.query('SELECT * FROM actor', function(err, rows) {
    if(err) throw err;

    var user = rows[0];
    console.log(user);

  });

  res.send();
});

This is the result in the console:

node-databases> node .\database\db-1.js
RowDataPacket {
  actor_id: 1,
  first_name: 'PENELOPE',
  last_name: 'GUINESS',
  last_update: 2006-02-15T10:34:33.000Z }

I want to be able to take that and send it in the response to the browser.

Replace console.log with res.send thus sending response within the callback — wlh
– wlh, Commented May 25, 2017 at 3:51
You're a genius! I actually figured this out while trying Knex, and when you told me about that it all made sense. Thank you!!! Write that as an answer and I'll give you some internet points. — pk36
– pk36, Commented May 25, 2017 at 4:05

wlh · Accepted Answer · 2017-05-25 04:07:58Z

1

Replace console.log with res.send thus sending response within the callback.

answered May 25, 2017 at 4:07

wlh

3,5451 gold badge21 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

Create an object with mysql query

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