update Person set FirstName = 'Fred',SecondName = 'wanli' WHERE id = 6

 

-- 清空name字段,数据设置为空
update Person set name = null

 

posted @ 2020-08-04 10:16  万里哥  阅读(77)  评论(0编辑  收藏  举报