Error when trying to run a simple program in node js

Question

I'm new to node js when i try to execute the below program am getting an exception as

var mysql = require('mysql');

var connection = mysql.createConnection({
    host : 'localhost',
    user : 'root',
    password : 'Gemini*123',
    database : 'test'
});

connection.connect();

var queryString = "select * user_details";

connection.query(queryString, function(err, rows, fields) {
    if (err) throw err;

    for (var i in rows) {
        console.log('Post Titles: ', rows[i].user_name);
    }
});

connection.end();

"Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'user_details' at line 1"?

Thanks

user3398633 · Accepted Answer · 2014-07-11 12:58:33Z

2

Your query String should be var querystring = "SELECT * FROM user_details" and not SELECT * user_details

answered Jul 11, 2014 at 12:58

user3398633

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

Comments

Filipe Cabaco · Accepted Answer · 2014-07-11 12:59:26Z

0

You forgot to put 'From' on your query:

var queryString = "select * from user_details";

answered Jul 11, 2014 at 12:59

Filipe Cabaco

413 bronze badges

Comments

Mark K Cowan · Accepted Answer · 2014-07-11 13:03:05Z

0

As already pointed out, your SQL is wrong - you missed out the FROM keyword from your FROM clause.

Your for loop also might result in an error

for (var i in rows) will iterate over all the properties of the object. You probably just want to iterate over the entries of the array, so you'll want to iterate over just the indices instead

for (var idx = 0; idx < rows.length; idx++) {
  var row = rows[idx];
  ...
}

or you can go functional:

rows.forEach(function (row) {
  ...
}

answered Jul 11, 2014 at 13:03

Mark K Cowan

1,9021 gold badge23 silver badges28 bronze badges

Collectives™ on Stack Overflow

Error when trying to run a simple program in node js

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related