Sometimes it’s necessary to perform a bulk update to a MySQL database table, to reset all rows to 0 or to add a particular piece of text to each item and so on.
The easiest way to do this is to use the SQL tab for the chosen table and run a query.
For example, if `field` contained a 1 in every row, to change every row to 0 the SQL query would be:
UPDATE `tablename` SET `field`=0
A nice and simple way to bulk update a MySQL database table.
Stumble Upon
Del.icio.us
Buzz
