Node js insert Mysql doesnt work

Question

this is part of the code i use

var insertedData = {
        name: 'testname',
        score: '1337'
    };
connect.query('INSERT INTO table SET ?', insertedData, function(error, result){

and this is the error i got

{ [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 'table SET name = 'Hek', score = '12'' at line 1]code: 'ER_PARSE_ERROR', errno: 1064, sqlState: '42000',index: 0 }

Mureinik · Accepted Answer · 2016-09-14 20:23:52Z

1

table is a reserved word in MySQL. I'd advise to rename your table to something else. If this is absolutely not a possibility for you, you can escape it with backticks:

connect.query('INSERT INTO `table` SET ?', insertedData, function(error, result){

answered Sep 14, 2016 at 20:23

Mureinik

316k54 gold badges395 silver badges404 bronze badges

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

2 Comments

Shaharyar Over a year ago

Good find, but its an insert statement actually. Still incorrect

Mureinik Over a year ago

@Shaharyar INSERT ... SET is a valid syntax in MySQL. It's not standard ANSI, but it's perfectly fine for MySQL.

Collectives™ on Stack Overflow

Node js insert Mysql doesnt work

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related