alexville Posted April 8, 2006 Share Posted April 8, 2006 How do I do that? Quote Link to comment https://forums.phpfreaks.com/topic/6874-modifying-many-rows-in-a-database-at-one-time-in-phpmyadmin/ Share on other sites More sharing options...
IceHawk Posted April 8, 2006 Share Posted April 8, 2006 Depending on the change you're trying to make you can simply write a query to do it and run it from inside PHPMyAdmin. If you're modifying a lot of rows, that's generally the best way to do it. If you provide more info I can help with the query if needed. Quote Link to comment https://forums.phpfreaks.com/topic/6874-modifying-many-rows-in-a-database-at-one-time-in-phpmyadmin/#findComment-25026 Share on other sites More sharing options...
alexville Posted April 9, 2006 Author Share Posted April 9, 2006 I want to change a number in every row to 0 insted of what they have now. Does that help? Quote Link to comment https://forums.phpfreaks.com/topic/6874-modifying-many-rows-in-a-database-at-one-time-in-phpmyadmin/#findComment-25188 Share on other sites More sharing options...
IceHawk Posted April 10, 2006 Share Posted April 10, 2006 If you're doing that to every single row in the table regardless of the columns current value then you would just need to do;update [table] set [column] = 0 Quote Link to comment https://forums.phpfreaks.com/topic/6874-modifying-many-rows-in-a-database-at-one-time-in-phpmyadmin/#findComment-25383 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.