Syntax error in MySQL statement, unhelpful error message

Question

I have a MySQL server and I am trying to use

INSERT INTO servers (ip, version, motd, players, plugins, time)
VALUES ('--.---.---.--', '1.13.2', 'redacted', '0', '1', NOW())
ON DUPLICATE KEY UPDATE;

to insert data, but this error message popped up:

ERROR 1064 (42000): 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 '' at line 1

I tried this query again on LibreOffice Base and these messages popped up:

SQL Status: HY000
Error code: 1000
Syntax error in SQL statement

SQL Status: HY000
Error code: 1000
syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE

Any help?

Does redacted contain a single quote? Can you show your actual code? — Blue
– Blue, Commented Dec 10, 2018 at 15:06
On duplicate key update what? Is that your complete insert statement? — P.Salmon
– P.Salmon, Commented Dec 10, 2018 at 15:07
@FrankerZ It only contains alphabet and spaces, the string is escaped — Dolf
– Dolf, Commented Dec 10, 2018 at 15:12

Dolf · Accepted Answer · 2018-12-10 15:15:45Z

1

Missing statement after on duplicate update

answered Dec 10, 2018 at 15:15

Dolf

1349 bronze badges

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

1 Comment

tadman Over a year ago

Yeah, MySQL is asking "on duplication update...what?"

Collectives™ on Stack Overflow

Syntax error in MySQL statement, unhelpful error message

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related