Node.js MySQL query execution flow

Question

If I have a MySQL query that returns a value that will be used again in a WHERE clause, will this work with Node.js' asynchronous execution flow?

Generally this might be the case:

SELECT
customerId FROM Customers
WHERE customerName=nikolas

Then the result would be stored like so:

var customerId = customerId

And reused in another query:

SELECT
orderId FROM Orders
WHERE customerId=customerId

Will this fetch me the orderId of the customer Nikolas that was returned in the first query?

Will written queries run sequentially?

hexacyanide · Accepted Answer · 2013-10-07 00:35:11Z

1

It really depends on the module you're using. One of the most commonly used drivers, node-mysql, is asynchronous, so the code won't run sequentially. Instead, you'd have to use callbacks:

var query1 = 'SELECT customerId FROM Customers WHERE customerName = nikolas';
var query2 = 'SELECT orderId FROM Orders WHERE customerId = ';

connection.connect();
connection.query(query1, function(err, rows, fields) {
  var customerId = rows[0].customerId;
  connection.query(query2 + customerId, function(err, rows, fields) {
    connection.end();
    // results are here
  });
});

In Node.js, you usually want to write asynchronous code. There probably is a synchronous MySQL driver module somewhere, but most don't have a case where they would want to block their process with a synchronous database call.

answered Oct 7, 2013 at 0:35

hexacyanide

92.4k31 gold badges168 silver badges162 bronze badges

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

Comments

MBT · Accepted Answer · 2018-05-11 09:42:20Z

0

In the code written by @hexacyanide. The second query won't run until the first query has run, because the code is waiting for the response of the first query. So that answers your doubt of sequentially. And also you don't need to use two queries for this. You can simply join the two tables and get the result in a single query. Something like this:

SELECT orders.orderId 
       FROM Orders orders 
       JOIN Customers customers 
       ON orders.customerId = customers.customerId
       WHERE customers.customerName='Nikolas'

edited May 11, 2018 at 9:42

MBT

24.6k23 gold badges96 silver badges113 bronze badges

answered May 11, 2018 at 9:08

Ashish Prasher

611 silver badge5 bronze badges

Collectives™ on Stack Overflow

Node.js MySQL query execution flow

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related