NodeJS - how can get mysql result with executed query?

Question

I am new in NodeJS with mysql (npm install mysql).

When I try to execute query like

connection.query("select ?? from users where id = ?",[["id","fname","lname"],req.body.userid],function (err, rows) { **here I want query which above executed** });

I want query in callback function which executed.

How can I get it??.

yosiweinreb · Accepted Answer · 2015-12-03 12:13:23Z

8

var c = connection.query("select ?? from users where id = ?",[["id","fname","lname"],req.body.userid],function (err, rows) { console.log(c.sql) });

answered Dec 3, 2015 at 12:13

yosiweinreb

4854 silver badges12 bronze badges

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

1 Comment

Dev Over a year ago

How I will get the query if I am using promise?

Akram Saouri · Accepted Answer · 2015-12-03 11:27:13Z

connection.query("select ?? from users where id = ?",[["id","fname","lname"],req.body.userid],function (err, rows) { res.send(rows); });

also in preference swith the string query to :

"select id,fname,lname from users where id = '"+req.body.userid+"'"

actually, I want query in Call Back function. No I don't want switch param as string query.

Collectives™ on Stack Overflow

NodeJS - how can get mysql result with executed query?

2 Answers 2

1 Comment

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Linked

Related