Update Multiple Rows At Once With Different Values in MySQL

5 Responses to Update Multiple Rows At Once With Different Values in MySQL

1. Jules Manson says:

   July 25, 2010 at 5:40 pm

   Very good post. I was looking for something exactly like this. My PHP is fairly good so I didn’t need the PHP part but I definitely needed to see how to write a MySQL statement that does exactly this.

   May I ask, do you know or use MySQLi prepared statements? If so I would love to see an article exactly like this using prepared statements. I find writing the php for MySQLi prep statements a bit tricky.

   Thanks again for a great post.

   Jules

   Reply
2. stuporglue says:

   July 25, 2010 at 7:05 pm

   I’m happy that this was helpful to you!

   –

   “May I ask, do you know or use MySQLi prepared statements? If so I would love to see an article exactly like this using prepared statements.”

   I’m aware of prepared statements, but I haven’t actually used them. Sorry!

   Reply
3. Steve Perkins says:

   August 3, 2011 at 6:09 am

   Hi,

   You are a genious been looking for something like this.

   Really helpful and kind of you to put an example of such.

   I have put the PHP code around it and works a treat. :-)

   Thanks

   Steve

   Reply
4. anon says:

   March 1, 2012 at 11:41 am

   Thank you so much for writing this, this is literally the only article I could find anywhere that spelled it out simply.

   I wasn’t quite sure about the ELSE parts though. For example you put

   `column3` = CASE
WHEN `id`='1034786' THEN 'Text One'
WHEN `id`='1037099' THEN 'Text Two'
WHEN `id`='1034789' THEN 'Text Three'
ELSE `title` END

   Surely it should be ELSE `column3` END ?

   Reply
   • stuporglue says:

     March 5, 2012 at 9:04 pm

     Yes, you’re correct.

     I anonymized some private code so it would make more sense in the blog post, and missed that one. Fixing it now.

     Reply