- - Code, Content, and Presentation
- -- Databases
- ---- Conditional mysql insert question - how to prevent duplicates
brotherhood_of_LAN - 10:45 pm on Aug 3, 2011 (gmt 0)
That would be fine. ON DUPLICATE KEY essentially is an INSERT or UPDATE in the one query. It's just like a regular insert/update.
Thread source: http://www.webmasterworld.com/databases_sql_mysql/4347419.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com