修改字段值 

/修改字段值
UPDATE login  SET name = ''Mary''   WHERE [条件];


mysql> update test set name='hubei' where age=29;
Query OK, 1 row affected (0.40 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql>

 

posted @ 2016-10-30 12:45  Xiao|Deng  阅读(164)  评论(0)  编辑  收藏  举报