MySQL Forums
Forum List  »  Character Sets, Collation, Unicode

Advanced Search
New Topic

Re: LIMIT on INSERT - necessary with unique keys?
Posted by: Bradley Cater
Date: September 11, 2009 08:27AM

Whoops...obviously that query should have been:

UPDATE my_table SET my_field0 = my_value0, my_field1 = my_value1
WHERE my_field2 = my_value2 LIMIT 1;

Never ask for help while tired.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
LIMIT on INSERT - necessary with unique keys?
4787
Bradley Cater
September 10, 2009 06:35AM
Re: LIMIT on INSERT - necessary with unique keys?
2416
Bradley Cater
September 11, 2009 08:27AM
Re: LIMIT on INSERT - necessary with unique keys?
2381
Rick James
September 12, 2009 09:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.