Page 1 of 1

Reseting a column to zero?

Posted: Tue Jul 29, 2003 5:21 pm
by Rebajas
I have a column which logs a request for the information on that row. I need to reset the column every month so I can start from scratch frequently enough to get useful information.

What is the best way to reset this column, it has about 1000 rows in?

Cheers,



Tony.

Posted: Tue Jul 29, 2003 7:19 pm
by jmarcv
update table SET column ='';

Without a where clause it will do all the records.