14.笔记 MySQL学习——删除更新已有行

14.笔记 MySQL学习——删除更新已有行

删除某些行如下：

DELETE FROM tbl_name WHERE which rows todelete;

例如：

mysql> delete from president where state='OH';

Query OK, 7 rows affected (0.00 sec)

更新如下：

mysql> update student set name='George';

Query OK, 31 rows affected (0.00 sec)

Rows matched: 31  Changed: 31 Warnings: 0