Multiple Updates in MySQL

by

Yes, that’s possible – you can use INSERT … ON DUPLICATE KEY UPDATE.

Using your example:

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);

More Related Contents:

  1. MySQL, update multiple tables with one query
  2. UPDATE multiple rows with different values in one query in MySQL
  3. mysql update column with value from another table
  4. update multiple rows using limit in mysql?
  5. MySQL/SQL: Update with correlated subquery from the updated table itself
  6. What are differences between INSERT and UPDATE in MySQL?
  7. MySql – Way to update portion of a string?
  8. MySQL UPDATE syntax with multiple tables using WHERE clause
  9. The best way to remove value from SET field?
  10. Update MySQL with if condition
  11. Update multiple rows with multiple ‘where’ clauses for each individual row
  12. MySQL update statement to store ranking positions
  13. get first occurrence of last changed value of a column [closed]
  14. MySQL – Rows to Columns
  15. ROW_NUMBER() in MySQL
  16. multiple query same table but in different columns mysql
  17. How can I temporarily disable a foreign key constraint in MySQL?
  18. How to do a batch insert in MySQL
  19. Return default result for IN value regardless
  20. How can I search (case-insensitive) in a column using LIKE wildcard?
  21. sql joins as venn diagram
  22. How can I join multiple SQL tables using the IDs?
  23. MySQL, better to insert NULL or empty string?
  24. Why do results from a SQL query not come back in the order I expect?
  25. MySQL combine two columns and add into a new column
  26. How to set a MySQL row to READ-ONLY?
  27. Getting first day of the week in MySql using Week No
  28. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  29. What happens when I exhaust a bigint generated key? How to handle it?
  30. is there a length limit to group_concat or another reason why it would not work on a text field

Leave a Comment