/修改字段值
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>