Error Updating multiple value sets in MySQL
I use the following query to update my database. It does not work, giving me a syntax error. Any Ideas?
UPDATE table
SET browser = CASE ID
WHEN '11' THEN 'Google Chrome 2.0'
WHEN '49' THEN 'Google Chrome 2.0'
WHEN '52' THEN 'Google Chrome 2.0'
END, SET os = CASE ID
WHEN '11' THEN 'Microsoft Windows'
WHEN '49' THEN 'Microsoft Windows'
WHEN '52' THEN 'Microsoft Windows'
END, SET language = CASE ID
WHEN '11' THEN 'US English 5'
WHEN '49' THEN 'US English 5'
WHEN '52' THEN 'US English 5'
END WHERE ID IN (11,49,52)
Thanks,
Ronnie268
Failure isn't an option - It comes bundled with Windows
π ~= 3.14
3*14 = 42
Coincidence? I think not.
π = The Answer to Life, the Universe, and Everything.
Bookmarks