mysql怎么修改表中某个数据

update 表名 set 字段名=‘新内容’ + where条件

mysql> select*from tbl;
+-----------+--------------+---------------+-----------------+
|        id |        title |     author   |        date      |
+-----------+--------------+---------------+-----------------+
|         1 | 学习 PHP       | 菜鸟教程      | 2019-10-1       |
|         2 | 学习 MySQL     |   菜鸟教程    | 2019-10-1       |
|         3 | JAVA 教程      | RUNOOB.COM   | 2019-10-1       |
+-----------+--------------+---------------+-----------------+
3 rows in set (0.04 sec)
 
mysql> update tbl set date='2018-08-08' where `id`=3;
Query OK, 1 row affected (0.16 sec)
Rows matched: 1  Changed: 1  Warnings: 0
 
mysql> select*from tbl;
+-----------+--------------+---------------+-----------------+
|        id |        title |     author   |        date      |
+-----------+--------------+---------------+-----------------+
|         1 | 学习 PHP       |  菜鸟教程     | 2019-10-1       |
|         2 | 学习 MySQL     |  菜鸟教程     | 2019-10-1       |
|         3 | JAVA 教程      | RUNOOB.COM   | 2018-08-08      |
+-----------+--------------+---------------+-----------------+
3 rows in set (0.04 sec)