cramhead/mysqlBulkUpdate.sql

Created September 13, 2019 20:26

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/cramhead/5d6d7c233be32668ef7ce76cfc828091.js"></script>
Save cramhead/5d6d7c233be32668ef7ce76cfc828091 to your computer and use it in GitHub Desktop.

Download ZIP

Updates rows when the ids conflict with existing data

Raw

mysqlBulkUpdate.sql

 INSERT INTO user (id, uid) VALUES (1, 'uid1'), (2, 'uid2'), (3, 'uid3') ON DUPLICATE KEY UPDATE id=VALUES(id), uid=VALUES(uid);

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment