Skip to content

Instantly share code, notes, and snippets.

@heylastway

heylastway/Multiple Updates.sql

Created October 31, 2019 15:19
Show Gist options
  • Save heylastway/30ac41e2977917a8617f34f370527ed4 to your computer and use it in GitHub Desktop.
Save heylastway/30ac41e2977917a8617f34f370527ed4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Multiple Updates.sql
INSERT INTO table (id,Col1,Col2) VALUES (1,1,1),(2,2,3),(3,9,3),(4,10,12)
ON DUPLICATE KEY UPDATE Col1=VALUES(Col1),Col2=VALUES(Col2);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment