MySQL On Duplicate Insert

Question

I'm new to MySQL so I can't figure out whats wrong in the syntax.

$sql = "INSERT INTO UsersTest (user_ip, email, firstname, lastname, city, state, country) VALUES ('$user_ip', '$email', '$firstname', '$lastname', '$city', '$state', '$country') ON DUPLICATE KEY UPDATE (user_ip = '$user_ip', firstname = '$firstname', lastname = '$lastname', city = '$city', state = '$state', country = '$country')";

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_ip = ...

All the variables exists and are printed correctly.

Mureinik · Accepted Answer · 2015-07-04 19:22:27Z

3

The on duplicate key update clause shouldn't have parentheses around it:

$sql = "INSERT INTO UsersTest (user_ip, email, firstname, lastname, city, state, country) 
VALUES ('$user_ip', '$email', '$firstname', '$lastname', '$city', '$state', '$country') 
ON DUPLICATE KEY UPDATE user_ip = '$user_ip', firstname = '$firstname', lastname = '$lastname', city = '$city', state = '$state', country = '$country'";

answered Jul 4, 2015 at 19:22

Mureinik

316k54 gold badges400 silver badges405 bronze badges

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

Comments

yxre · Accepted Answer · 2015-07-04 19:22:09Z

2

Removing the parenthesis around the duplicate key update expressions should do the trick.

answered Jul 4, 2015 at 19:22

yxre

3,71423 silver badges20 bronze badges

Collectives™ on Stack Overflow

MySQL On Duplicate Insert

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related