1,update语句。

update更新一列或多列的值。

如。

update doughunt _ratings set type = 'glazed' where type = 'plain glazed';

update your_table set first_column = 'newvalue', second_column = 'another_value'

update table set column_name = newvalue where column_name = somevalue

 

update drink_info set cost = cost + 1 where drink_name = 'Blue moon'

or drink_name = 'oh, gosh'