Query not working using node.js node-mysql

Question

Whats wrong with my query? im having this error:

con.query(
           'SELECT nick FROM channels WHERE room=1room',
           function(err, rows) {
               if (err) throw err;
               console.log(rows);
           }
       );

I tried this, and i have the same error:

var room = "1room";
       con.query(
           'SELECT nick FROM channels WHERE room=' + room,
           function(err, rows) {
               if (err) throw err;
               console.log(rows);
           }
       );

displaynamevalue · Accepted Answer · 2017-02-06 21:35:11Z

2

It is treating 1room as a variable, not a string. Wrap it in quotes and it should work.

con.query(
   'SELECT nick FROM channels WHERE room="1room"',
   function(err, rows) {
       if (err) throw err;
       console.log(rows);
   }
);

For your second example, you should get in the habit of escaping the variables you use in queries for security reasons (to prevent SQL injection).

var room = "1room";
con.query(
   'SELECT nick FROM channels WHERE room=?',
   [room],
   function(err, rows) {
       if (err) throw err;
       console.log(rows);
   }
);

answered Feb 6, 2017 at 21:35

displaynamevalue

1384 bronze badges

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

Collectives™ on Stack Overflow

Query not working using node.js node-mysql

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