Swap Insert for Update When Key Exists
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 if there is already a row with that key.
- Web Address: http://codespatter.com/2008/04/30/swap-insert-for-update-when-key-exists/
- Short Name: qejuhivach
-
Short Link: http://ma.gnolia.com/qejuhivach
-
Tags: mysql, insert, sql, syntax, duplicate
- Saved to CodeGrrl by pyroman on April 30, 2008.
1 user has commented on this bookmark
| Name | Title | Rating | When | |
|---|---|---|---|---|
 |
pyroman | Swap Insert for Update When Key Exists |
Not rated yet.
|
April 30, 2008 |
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 e... |
||||
3 other groups have this bookmark in their collection
| Name | Title | Rating | When | |
|---|---|---|---|---|
| MySQL | Swap Insert for Update When Key Exists |
Not rated yet.
|
April 30, 2008 |
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 e... |
||||
| SQL techniques | Swap Insert for Update When Key Exists |
Not rated yet.
|
April 30, 2008 |
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 e... |
||||
|
| SQL | Swap Insert for Update When Key Exists |
Not rated yet.
|
April 30, 2008 |
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 e... |
||||