在MySQL中显示除一个之外的所有记录

您可以使用IN()在MySQL中显示除一个之外的所有记录。首先让我们创建一个表 –

mysql> create table DemoTable
(
   Id int,
   FirstName varchar(20)
);
Query OK, 0 rows affected (0.57 sec)

使用insert命令向表中插入一些记录 –

mysql> insert into DemoTable values(100,'Larry');
Query OK, 1 row affected (0.31 sec)
mysql> insert into DemoTable values(10,'Chris');
Query OK, 1 row affected (0.19 sec)
mysql> insert into DemoTable values(110,'Robert');
Query OK, 1 row affected (0.15 sec)
mysql> insert into DemoTable values(90,'David');
Query OK, 1 row affected (0.20 sec)

以下是使用select语句从表中显示所有记录的查询 –

mysql> select *from DemoTable;

这将产生以下输出 –

+------+-----------+
| Id   | FirstName |
+------+-----------+
| 100  | Larry     |
| 10   | Chris     |
| 110  | Robert    |
| 90   | David     |
+------+-----------+
4 rows in set (0.00 sec)

以下是在MySQL中显示除一个之外的所有记录的查询 –

mysql> select *from DemoTable where Id IN(110,90,100);

这将产生以下输出 –

+------+-----------+
| Id   | FirstName |
+------+-----------+
| 100  | Larry     |
| 110  | Robert    |
| 90   | David     |
+------+-----------+
3 rows in set (0.00 sec)