MySQL Update Multiple Columns Issue

Question

This seems to be a really simple query, but somehow I keep getting errors...

Basically, I just got a bunch of information from a user, and now I'm going to update their record in the users table in one query:

UPDATE users SET timezone = 'America/New_York', SET updates = 'NO', SET verified = 'YES' WHERE id = '1'

However, after running that, I get the following 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 'SET updates = 'NO', SET verified = 'YES' WHERE id = '1'' at line 1".

Any help is much appreciated.

Like Yoda says, remove the extra "SET" bits. The syntax is UPDATE ... SET field=value, field=value, field=value — Marc B
– Marc B, Commented Jan 31, 2011 at 4:01

yoda · Accepted Answer · 2011-01-31 03:55:36Z

9

UPDATE users SET timezone = 'America/New_York', updates = 'NO', verified = 'YES' WHERE id = '1'

answered Jan 31, 2011 at 3:55

yoda

11k19 gold badges68 silver badges94 bronze badges

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

Comments

Joko Wandiro · Accepted Answer · 2011-01-31 04:01:12Z

4

Your update syntax is wrong, you have to write syntax SET just once.

UPDATE users SET col1= value1, col2= value2, col3= value3 WHERE condition;

More information about update UPDATE MANUAL

answered Jan 31, 2011 at 4:01

Joko Wandiro

1,9872 gold badges18 silver badges29 bronze badges

Comments

bsanneh · Accepted Answer · 2011-01-31 09:37:19Z

0

Set have to be used once no matter how many columns you are updating .your query will be :-

UPDATE users SET timezone = 'America/New_York', updates = 'NO',verified = 'YES' WHERE id = '1'

answered Jan 31, 2011 at 9:37

bsanneh

5211 gold badge9 silver badges17 bronze badges

Collectives™ on Stack Overflow

MySQL Update Multiple Columns Issue

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related