Log in

View Full Version : Change all values in a table column


chrsschb
12-03-2008, 07:11 PM
I'm trying to figure out the mysql command to change all values in a table column.

Basically what I'm trying to do is remove the recommend level / required level from all items.

Thanks.

Andrew80k
12-03-2008, 07:44 PM
update table_name set column_name ='some value';

chrsschb
12-03-2008, 08:01 PM
That worked perfect thanks!