让我们首先创建一个表-mysql> create table DemoTable778 (
ClientId varchar(100),
ClientName varchar(100)
);
使用插入命令在表中插入一些记录-mysql> insert into DemoTable778 values('J-101','John');
mysql> insert into DemoTable778 values('A-102','Adam');
mysql> insert into DemoTable778 values('C-103','Chris');
mysql> insert into DemoTable778 values('D-104','David');
mysql> insert into DemoTable778 values('R-105','Robert');
使用select语句显示表中的所有记录-mysql> select *from DemoTable778;
这将产生以下输出-+----------+------------+
| ClientId | ClientName |
+----------+------------+
| J-101 | John |
| A-102 | Adam |
| C-103 | Chris |
| D-104 | David |
| R-105 | Robert |
+----------+------------+
5 rows in set (0.00 sec)
从MySQL表中选择行并使用IN()-显示mysql> select *from DemoTable778 where ClientId IN('J-101','A-102','C-103','D-104','R-105');
这将产生以下输出-+----------+------------+
| ClientId | ClientName |
+----------+------------+
| J-101 | John |
| A-102 | Adam |
| C-103 | Chris |
| D-104 | David |
| R-105 | Robert |
+----------+------------+
5 rows in set (0.00 sec)