mysql updating best practices
mysql updating best practices
- Started
- Last post
- 5 Responses
- jpea
would it be ok to have a mysql UPDATE statement within a loop, or is there another way to update multiple rows in sequential order?
- fusionpixel0
that sounds ok, any other options?
- cosmo0
There is nothing wrong with that.
- neverblink0
I don't believe there is a way to do this inside one mysql-query so doing this in a loop would be the only way..
- maximillion_0
you could update multiple rows with the same value otherwise the loop is fine
- jpea0
great, thanks for the input ya'll.