Update multiple rows with one query?

by 
UPDATE person
    SET name = CASE id
        WHEN 1 THEN 'Jim'
        WHEN 2 THEN 'Mike'
        WHEN 3 THEN 'Precious'
    END,
    sex = CASE id
        WHEN 1 THEN 'female'
        WHEN 2 THEN 'male'
        WHEN 3 THEN 'male'
    END
WHERE id IN (1,2,3)

More Related Contents:

  1. MySQL: Alternatives to ORDER BY RAND()
  2. MySQL LIKE IN()?
  3. Auto Increment after delete in MySQL
  4. Unioning two tables with different number of columns
  5. NULL in MySQL (Performance & Storage)
  6. In MySQL queries, why use join instead of where?
  7. MySQL function to find the number of working days between two dates
  8. MySQL Trigger to prevent INSERT under certain conditions
  9. Importance of varchar length in MySQL table
  10. Stored Procedure with optional “WHERE” parameters
  11. mySQL :: insert into table, data from another table?
  12. Return 0 if field is null in MySQL
  13. SQLite – ORDER BY RAND()
  14. How to search multiple columns in MySQL?
  15. MySQL – Selecting data from multiple tables all with same structure but different data
  16. Can a stored procedure/function return a table?
  17. Adding a new SQL column with a default value
  18. Selecting all corresponding fields using MAX and GROUP BY
  19. MySQL full text search for words with three or less letters
  20. MySQL’s alternative to T-SQL’s WITH TIES
  21. The difference between ‘AND’ and ‘&&’ in SQL
  22. Can I use a MySQL database with an App Engine application
  23. How can I make an average of dates in MySQL?
  24. What is the best way to generate ranks in MYSQL?
  25. What does collation mean?
  26. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  27. sql pulling a row for next or previous row of a current row
  28. Row Rank in a MySQL View
  29. Select Rows with Maximum Column Value group by Another Column
  30. mysql GROUP_CONCAT duplicates

Leave a Comment