what is wrong with this update command

[random]

This is the command:

update users set (last_act,count) = ('2004-06-07 22:01:12','0') where uname='random';

Spits back this error:

Check the manual that corresponds to your MySQL server version for the right syntax to use near '(last_act,count) = ('2004-06-07 23:28:51','1') WHERE uname='

thanks

[joshie]

the update syntax should be like this:

update users set last_act = '2004-06-07 22:01:12', count = '0' where uname = 'random';


hope this helps