UPDATE修改name

Update 表 set name='修改后的' where name='原来的'

MariaDB [test]> select * from T1;
+------+-------+
| name | sex |
+------+-------+
| wu | jiabo |
| 11 | 22 |
| wu | bing |
| li | ming |
+------+-------+
4 rows in set (0.00 sec)

MariaDB [test]>
MariaDB [test]>
MariaDB [test]> update name SET name='zhang' where name='11';
ERROR 1146 (42S02): Table 'test.name' doesn't exist
MariaDB [test]> update name SET name='zhang' where sex='22';
ERROR 1146 (42S02): Table 'test.name' doesn't exist
MariaDB [test]> update T1 SET name='zhang' where name='11';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

MariaDB [test]> select * from T1;
+-------+-------+
| name | sex |
+-------+-------+
| wu | jiabo |
| zhang | 22 |
| wu | bing |
| li | ming |
+-------+-------+
4 rows in set (0.00 sec)

MariaDB [test]> update T1 SET sex='san' where name='zhang';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

MariaDB [test]> select * from T1;
+-------+-------+
| name | sex |
+-------+-------+
| wu | jiabo |
| zhang | san |
| wu | bing |
| li | ming |
+-------+-------+
4 rows in set (0.00 sec)