«« Next » « Previous
«« Next » « Previous

Link Details

Link 80196 thumbnail

By gallard
via codespatter.com
Submitted: May 09 / 12:40

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.
  • 2
  • 0
  • 91
  • 13

Add your comment


Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Voters For This Link (2)



Voters Against This Link (0)