让我们首先创建一个表-mysql> create table DemoTable
-> (
-> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
-> Name varchar(100),
-> Age int
-> );
使用插入命令在表中插入一些记录-mysql> insert into DemoTable(Name,Age) values('John',21);
mysql> insert into DemoTable(Name,Age) values('Carol',22);
mysql> insert into DemoTable(Name,Age) values('David',23);
使用select语句显示表中的所有记录-mysql> select *from DemoTable;
输出结果
这将产生以下输出-+----+-------+------+
| Id | Name | Age |
+----+-------+------+
| 1 | John | 21 |
| 2 | Carol | 22 |
| 3 | David | 23 |
+----+-------+------+
3 rows in set (0.00 sec)
这是排除特定行的子查询,名称为Carol-mysql> select *from DemoTable
-> where Name not in (select Name from DemoTable where Name='Carol'
-> );
输出结果
这将产生以下输出-+----+-------+------+
| Id | Name | Age |
+----+-------+------+
| 1 | John | 21 |
| 3 | David | 23 |
+----+-------+------+
2 rows in set (0.00 sec)