Insert or update if key exists |
[eluser]Bramme[/eluser]
Hey everybody I have a table that stores options selected by a user. I want every user to have a record in that table that gets upated as he makes changes. When a new user hasn't selected any options in the past, he ofcourse doesn't have a record. The easy way out would be to DELETE FROM table WHERE account_id = $id and then just insert a new row for the user, but I don't like to do those two queries. I read this page of the mysql documentation: http://dev.mysql.com/doc/refman/5.0/en/i...icate.html and thought it would work for me, but apparently it doesn't. I have put a "unique" key on my account_id field and use following query: INSERT INTO table (option_a, option_b, account_id) VALUES ('val1', 'val2', $id) ON DUPLICATE KEY UPDATE account_id = $id but this doesn't seem to work: a record is inserted the first time it is executed, and no new queries are added after it is ran again, but it also doesn't update the first record. Did I do anything wrong? |
Messages In This Thread |
Insert or update if key exists - by El Forum - 01-19-2011, 01:42 PM
Insert or update if key exists - by El Forum - 01-19-2011, 01:56 PM
Insert or update if key exists - by El Forum - 01-19-2011, 02:54 PM
Insert or update if key exists - by El Forum - 02-13-2011, 07:51 AM
|