cstegner Posted May 5, 2006 Share Posted May 5, 2006 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.-Chris Quote Link to comment https://forums.phpfreaks.com/topic/9153-can-you-update-one-column-in-every-row-of-a-database-without-using-a-while-statement/ Share on other sites More sharing options...
.josh Posted May 5, 2006 Share Posted May 5, 2006 update tablename set columnname = 'blah' Quote Link to comment https://forums.phpfreaks.com/topic/9153-can-you-update-one-column-in-every-row-of-a-database-without-using-a-while-statement/#findComment-33715 Share on other sites More sharing options...
cstegner Posted May 5, 2006 Author Share Posted May 5, 2006 I feel like a moron, at any rate...thank you.-Chris Quote Link to comment https://forums.phpfreaks.com/topic/9153-can-you-update-one-column-in-every-row-of-a-database-without-using-a-while-statement/#findComment-33719 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.