更新 UPDATE
更新表中特定行
mysql> update customers2 set cust_email = 'abc@example.com' where cust_id = '10006';
Query OK, 1 row affected (0.03 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from customers2;
+---------+----------------+---------------------+-----------+------------+----------+--------------+--------------+---------------------+
| cust_id | cust_name | cust_address | cust_city | cust_state | cust_zip