Jump to content

Archived

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

alexville

Modifying Many Rows in a database at one time in Phpmyadmin?

Recommended Posts

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.

Share this post


Link to post
Share on other sites
I want to change a number in every row to 0 insted of what they have now. Does that help?

Share this post


Link to post
Share on other sites
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

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.