Why am I getting an SQL Syntax error when trying to insert data into a row?

Question

I am getting a strange MYSQL error when trying to write a row to a database - every solution I have found concerning the topic hasn't been helpful. The query being passed is this:

"INSERT INTO StaffData (StaffID,Sort,Name,Department,Occupation,Roles,Phone,Email,Notes,Password) VALUES (@StaffID,@Sort,@Name,@Department,@Occupation,@Roles,@Phone,@Email,@Notes,@Password) ON DUPLICATE KEY UPDATE"

And the return value is:

"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"

The strange part to me is that it doesn't say where the error in syntax is, and I'm not sure why. Every other instance of this error I have found at least provides that.

Any help would be appreciated - thanks in advance!

Lionel Foxcroft · Accepted Answer · 2021-01-25 10:51:47Z

5

Your error is in the syntax for "ON DUPLICATE KEY UPDATE".

You can't end a query there, MYSQL wants you to specify exactly which fields should be updated and how. The docs for how to do that can be found here.

edited Jan 25, 2021 at 10:51

user15026033

answered Jan 25, 2021 at 3:06

Lionel Foxcroft

1,7773 gold badges13 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

Why am I getting an SQL Syntax error when trying to insert data into a row?

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