Reset all column values to 0

[papaface]

Hello,
How would I go about setting all the values in a given column to 0 using mysql?

e.g. I have 30 rows of records with 7 colums. I would like to set all the current values in column 4 and 5 to 0

regards

[MCP]

update table set col4=0, col5=0

[scotmcc]

If you don't set a 'WHERE' clause on a SQL statement it should update all of the rows in the table. For example:

[code]
UPDATE [TABLE] SET [COLUMN1] = 0, [COLUMN2] = 0;
[/code]

[papaface]

Thanks :)