Jump to content


This topic is now archived and is closed to further replies.


Can you update one column in every row of a database, without using a while statement?

Recommended Posts

Hi, once a week I want to update a certain column in every one of my members database rows. Now I was wondering if there was a certain query you could feed mysql to do this rather then using a while statement to go through every row.

For the odvious reason that if ther were one day 5 million users, well you get the idea.

You guys are always a huge help, and I am starting to try and help out those who I can.


Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.