pyroman's Bookmarks Tagged With "insert"

Swap Insert for Update When Key Exists

http://codespatter.com/2008/04/30/swap-insert-for-update-when-key-exists/
- Not rated yet.
- Details
When synchronizing tables or databases, sometimes it is useful to have a way to update a row if there is already an entry for a key. Using the MySQL syntax, ON DUPLICATE KEY UPDATE, it is possible to insert a row if it doesn’t exist or update it i… More
- Tags: mysql, insert, sql, syntax, duplicate
- Saved by pyroman on April 30, 2008.
Multiple Inserts with a Subquery

http://codespatter.com/2008/03/20/multiple-inserts-with-a-subquery/
- Not rated yet.
- Details
Important information on using a subquery when doing an insert.
- Tags: efficient, insert, multiple inserts, multiple records, MySQL, subqueries, syntax
- Saved by pyroman on March 20, 2008.