MYSQL - Update an entire Column

Question

I wanted to ask if there is a way to update an entire column with the same value. I want to run '0' down a column or '1'. I can use a php loop to do it but it will involve multiple DB calls etc.

Hopeing for a SQL statement that can run the same value down an entire mysql column.

cheers

Answer 1

Something a simple as UPDATE table1 SET column1=1; should do it.

Answer 2

UPDATE table_name SET column_name = 0

this will set the column value to 0 for all records, if this it want you want.