mysql

实例将更新数据表中 runoob_id 为 3 的 runoob_title 字段值：

SQL UPDATE 语句：

mysql> UPDATE runoob_tbl SET runoob_title='学习 C++' WHERE runoob_id=3;

Query OK, 1 rows affected (0.01 sec)

mysql> SELECT * from runoob_tbl WHERE runoob_id=3;

+-----------+--------------+---------------+-----------------+

| runoob_id | runoob_title | runoob_author | submission_date |

+-----------+--------------+---------------+-----------------+

| 3        | 学习 C++  | RUNOOB.COM    | 2016-05-06      |

+-----------+--------------+---------------+-----------------+

1 rows in set (0.01 sec)

从结果上看，runoob_id 为 3 的 runoob_title 已被修改。