How to do multiple mysql queries in one line in Node.js

Question

I'm trying to get results from multiple tables with one request from client. I first tried JOIN, but that would mean I'd have to have multiple rows that contain duplicate information. Then I decided to do a different query for each table separately, although I'm not sure know how cost efficient this is.

How should I construct the query so that it is accepted by Node.js? The one I'm trying to use now doesn't work if I don't use quotation marks to wrap the whole query, but if I do use them it complains there is an error with my query.

Here is the code for the query.

sql = "'SELECT * from `Ilmoittautuminen` WHERE `optunnus` LIKE ' + mysql.escape(reg.body.optunnus); 'SELECT * from `Jasenmaksu` WHERE `optunnus` LIKE ' + mysql.escape(reg.body.optunnus); 'SELECT * from `OppOikeus` WHERE `optunnus` LIKE ' + mysql.escape(reg.body.optunnus);"
console.log(sql);
connection.query(sql, function(err, rows){
    console.log(rows)
    if(err){
        console.log(err)
        res.json({
            success: false,
            message: err,
        });
    }else{
         queryResponse(res, rows);
    }
});

shivshankar · Accepted Answer · 2018-01-10 07:11:14Z

4

taking reference of https://github.com/mysqljs/mysql passs multipleStatements:true in your connection param and try with an exmaple

conn.query(`
SELECT * FROM posts limit 1;
SELECT * FROM Users limit 1;
`, (err, results)=>{
   console.log(err, results)
});

answered Jan 10, 2018 at 7:11

shivshankar

2,1351 gold badge20 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

How to do multiple mysql queries in one line 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