从MySQL表中选择行并使用IN()显示
让我们首先创建一个表-
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)