SQL – Update multiple records in one query

by

Try either multi-table update syntax

UPDATE config t1 JOIN config t2
    ON t1.config_name="name1" AND t2.config_name="name2"
   SET t1.config_value="value",
       t2.config_value="value2";

Here is a SQLFiddle demo

or conditional update

UPDATE config
   SET config_value = CASE config_name 
                      WHEN 'name1' THEN 'value' 
                      WHEN 'name2' THEN 'value2' 
                      ELSE config_value
                      END
 WHERE config_name IN('name1', 'name2');

Here is a SQLFiddle demo

More Related Contents:

  1. MySQL: Insert record if not exists in table [duplicate]
  2. How to declare a variable in MySQL?
  3. How do I escape special characters in MySQL?
  4. Enable remote MySQL connection: ERROR 1045 (28000): Access denied for user
  5. SQL counting all rows instead of counting individual rows
  6. MySQL case sensitive query [duplicate]
  7. Simulating MySQL’s ORDER BY FIELD() in Postgresql
  8. What does mysql error 1025 (HY000): Error on rename of ‘./foo’ (errorno: 150) mean?
  9. mysql fulltext search failure
  10. Adding a leading zero to some values in column in MySQL
  11. Using SQL to determine word count stats of a text field
  12. Update one MySQL table with values from another
  13. MySQL Order before Group by
  14. How to transpose mysql table rows into columns
  15. Regaining access to lost MySQL password for PHPMyAdmin on WAMP
  16. Export a MySQL Database to SQLite Database
  17. “193: %1 is not a valid Win32 application” bug with a new Rails Application
  18. How to display open transactions in MySQL
  19. MySQL – Select the last inserted row easiest way
  20. MySQL query, MAX() + GROUP BY
  21. Convert JSON array in MySQL to rows
  22. MySQL: Many tables or many databases?
  23. Select only last value using group by at mysql
  24. WooCommerce: Finding the products in database
  25. How to auto-load MySQL on startup on OS X Yosemite / El Capitan
  26. MySQL “ERROR 1005 (HY000): Can’t create table ‘foo.#sql-12c_4’ (errno: 150)”
  27. Mysql performance on 6 million row table
  28. MySQL Select Multiple VALUES
  29. Convert SQL Server query to MySQL [duplicate]
  30. Dump only the data with mysqldump without any table information?

Leave a Comment