mem0ri Posted March 12, 2007 Share Posted March 12, 2007 This question isn't so much on a MySQL syntax (that's already working fine), but on a 'what happens if' type situation. I'm using an: INSERT INTO table (cols) VALUES (vars) ON DUPLICATE KEY UPDATE cols=vars However...in my table I have TWO key values...and I'm wondering how the table would react if I had a table with: KEY 1 | KEY 2 x1 x2 x2 x1 And I made this call: INSERT INTO table (key1, key2) VALUES (x1, x1) ON DUPLICATE KEY UPDATE key1 = x1, key2 = x1 Wouldn't two rows call a 'duplicate'? Now...my ideal result would be for them to fold into one row containing the new information...but I know life can't be that easy... Quote Link to comment Share on other sites More sharing options...
btherl Posted March 12, 2007 Share Posted March 12, 2007 The answer is here: http://dev.mysql.com/doc/refman/5.1/en/insert-on-duplicate.html It will update one row at random. Naturally, doing this is not recommended Quote Link to comment Share on other sites More sharing options...
mem0ri Posted March 12, 2007 Author Share Posted March 12, 2007 Thank you...the reference and quick answer are both appreciated. Guess I'll have to do an initial search through, then insert/update. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.