nodejs npm mysql return single row handle

javascript mysql node.js node-mysql
Tyler Evans picture Tyler Evans · Jul 15, 2015 · Viewed 12.3k times · Source

Im using node and npm mysql to do some database work.

Is there any way to avoid using the result[0] , if i know Im only going to receive a single row?

connection.query({
    sql: "SELECT spend FROM `account` WHERE `name` = ? order by date desc limit 1",
    values: [market.name]
    }, function (error, results, fields) {
        market.fee = results[0].age;
        resolve(market);
    });

Answer

nalinc picture nalinc · Jul 15, 2015

The callback function of connection.query returns three values out of which the second one, is the resultset of query and hence an array of values.

Therefore, you must use result[0] even if you are sure that the resultset would contain just a single record.

Moreover, its somewhat query's own specification that decides what kind of data is supposed to be returned. mysql's SELECT is made to work this way(though you can limit the records) unlike mongodb's db.collection.findOne() where the query itself know it'll always return a single record

Related questions

Preventing SQL injection in Node.js

Is it possible to prevent SQL injections in Node.js (preferably with a module) in the same way that PHP had Prepared Statements that protected against them. If so, how? If not, what are some examples that might bypass the …

Read More
How to make login form in node.js using mysql database

I am new in node.js and i want to make a login page using express and mysql database,Please share with me your idea with example.

Read More
In node.js mysql query, check if no matching found

How can I check if no matching found in mysql (node.js)? mysql.query("select * from table1 where name = 'abcd'", function(error, result, field) { if(error) { exist(error); //No error } else if(result) { console.log(result); //displays '[]' exist(…

Read More