数据修改

MySQL 修改数据

MySQL 表中使用 update 语句来修改数据

使用 update 语句来修改数据，语法如下：

update 表名 set 列=值，列=值，.... where...

示例：

update Username set Username = 'Xin' where id=1;

修改成功如下：

mysql> update Username set Username = 'Xin' where id=1;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

// 原先表数据
mysql> select * from Username;
+------+------------+----------+
| id   | Username   | Password |
+------+------------+----------+
|    1 | steins_xin | 123456   |
+------+------------+----------+
1 row in set (0.00 sec)

// 修改表数据
mysql> select * from Username;
+------+----------+----------+
| id   | Username | Password |
+------+----------+----------+
|    1 | Xin      | 123456   |
+------+----------+----------+
1 row in set (0.00 sec)