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

相关文章

相关标签/搜索