Node.js MySQL Query Error

Question

I'm currently trying to implement a simple MySQL Database into my App. It should add a new User OR update if this User Exists. I'm working with Node.js mysql.

My code is:

INSERT INTO User ? ON DUPLICATE KEY UPDATE cost=VALUES(cost),
city=VALUES(city), romantik=VALUES(romantik),
kultur=VALUES(kultur), abenteuer=VALUES(abenteuer), 
familie=VALUES(familie), citytrip=VALUES(citytrip), 
kreuzfahrt=VALUES(kreuzfahrt)

and the output code is:

'INSERT INTO User `userId` = 566160350174682, `cost` = 400,
`city` = \'Berlin\', `romantik` = false,
`kultur` = true, `abenteuer` = true, `familie` = false,
`citytrip` = true, `kreuzfahrt` = false ON DUPLICATE KEY
UPDATE cost=VALUES(cost), city=VALUES(city), kultur=VALUES(kultur),
abenteuer=VALUES(abenteuer), familie=VALUES(familie),
citytrip=VALUES(citytrip), kreuzfahrt=VALUES(kreuzfahrt)'

This should work as far as I know but it always returns this 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 \'userId = 566160350174682, cost = 400, city = \'Berlin\' at line 1

Can Somebody explain why this is happening and how I can solve this?

Bhavik Patel · Accepted Answer · 2017-08-08 15:01:47Z

3

You have to use SET ..

Your query should be

INSERT INTO User SET `userId` = 566160350174682, `cost` = 400,
`city` = \'Berlin\', `romantik` = false, `kultur` = true, 
`abenteuer` = true, `familie` = false, `citytrip` = `kreuzfahrt` = false ON DUPLICATE KEY UPDATE cost=VALUES(cost), city=VALUES(city), kultur=VALUES(kultur),
abenteuer=VALUES(abenteuer), familie=VALUES(familie), citytrip=VALUES(citytrip), kreuzfahrt=VALUES(kreuzfahrt)

answered Aug 8, 2017 at 15:01

Bhavik Patel

1,0742 gold badges17 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

Node.js MySQL Query Error

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related