Reseting a column to zero?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Rebajas
Forum Newbie
Posts: 16
Joined: Tue Aug 20, 2002 9:35 am
Location: http://www.rebajas.co.uk/

Reseting a column to zero?

Post 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.
jmarcv
Forum Contributor
Posts: 131
Joined: Tue Jul 29, 2003 7:17 pm
Location: Colorado

Post by jmarcv »

update table SET column ='';

Without a where clause it will do all the records.
Post Reply