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'
本文转自鹅倌51CTO博客,原文链接:http://blog.51cto.com/kaixinbuliao/849869 ,如需转载请自行联系原作者