Page 1 of 1

Modifying all rows ?

Posted: Thu Apr 21, 2005 10:16 pm
by Death
Hi guys,

In my table I want to set an INT field in every row to 0.

What's the best way to do that ?

Thanks.

Posted: Thu Apr 21, 2005 10:59 pm
by John Cartwright

Code: Select all

UPDATE `table` SET `row` = 0