Update Multiple Rows With Different Values and a Single SQL Query

Update Multiple Rows With Different Values and a Single SQL Query | Karl Rixon

March 1 2011, 2:35pm

Use MySQL CASE to update multiple rows with different values all in one query.

Tags:
programming
php
Mysql
tutorial
database
performance
update
sql
multiple
query
CASE

Via: http://www.karlrixon.co.uk/articles/sql/update-multiple-rows-with-different-values-and-a-single-sql-query/

Your favourite external commenting service goes here! I recommend http://www.disqus.com

Blogs are evolving. You're looking at my Lifestream, a real-time flow of my activity across various websites, with the occasional blog post for nourishment.

kingkool68

Update Multiple Rows With Different Values and a Single SQL Query | Karl Rixon

Popular Tags

Search