alexville Posted April 8, 2006 Share Posted April 8, 2006 How do I do that? 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. 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? 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 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
Archived
This topic is now archived and is closed to further replies.