Page 1 of 1

Is there something wrong with this insert statement?

Posted: Wed Aug 23, 2006 7:30 pm
by GeXus

Code: Select all

INSERT INTO users (last_login) values (now()) where user_id = 3
Thanks

Posted: Wed Aug 23, 2006 7:35 pm
by volka
Yes.
where user_id = 3
has nothing to do with insert.
Are you looking for UPDATE or REPLACE?