SQL statement to change column value

artcoder · January 3, 2009, 3:52am

I have a table with 400 records. What is example SQL statement to change column “cars” to value of “1” for all records in the table?

runrunforest · January 3, 2009, 4:07am

“UPDATE car_table SET cars = 1”;

r937 · January 3, 2009, 4:13am

UPDATE car_table SET cars = 1

big difference!!