Setting all values in a MySQL field to 0

Question

I have the following Mysql 'test' table:

id -- number
1 -- 2
2 -- 33
3 -- 32
4 -- 162
5 -- 42
6 -- 142
7 -- 113
8 -- 12

What would be the query to turn all the values in field 'number' to 0?

I'm trying a kind of reset.

Thanks a ton!

Answer 1

Here:

UPDATE test SET number = 0;