Simple demo for IN : In « Select Clause « SQL / MySQL

1. SQL / MySQL
2. Select Clause
3. In

Simple demo for IN

  
/*
mysql> Drop table report;
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE TABLE report (
    ->        article INT(4),
    ->        dealer  CHAR(20),
    ->        price   DOUBLE(16,2)
    -> );
Query OK, 0 rows affected (0.05 sec)

mysql> INSERT INTO report VALUES (1,'A',4.45),
    ->                         (1,'B',5.45),
    ->                         (2,'A',16.67),
    ->                         (3,'B',6.12),
    ->                         (3,'C',2.78),
    ->                         (3,'D',2.34),
    ->                         (4,'D',21.29);
Query OK, 7 rows affected (0.01 sec)
Records: 7  Duplicates: 0  Warnings: 0

mysql> SELECT * FROM report;
+---------+--------+-------+
| article | dealer | price |
+---------+--------+-------+
|       1 | A      |  4.45 |
|       1 | B      |  5.45 |
|       2 | A      | 16.67 |
|       3 | B      |  6.12 |
|       3 | C      |  2.78 |
|       3 | D      |  2.34 |
|       4 | D      | 21.29 |
+---------+--------+-------+
7 rows in set (0.01 sec)

mysql> SELECT *
    -> FROM report
    -> WHERE dealer IN("A","C","D");
+---------+--------+-------+
| article | dealer | price |
+---------+--------+-------+
|       1 | A      |  4.45 |
|       2 | A      | 16.67 |
|       3 | C      |  2.78 |
|       3 | D      |  2.34 |
|       4 | D      | 21.29 |
+---------+--------+-------+
5 rows in set (0.00 sec)


*/

Drop table report;  

CREATE TABLE report (
       article INT(4),
       dealer  CHAR(20),
       price   DOUBLE(16,2)
);

INSERT INTO report VALUES (1,'A',4.45),
                        (1,'B',5.45),
                        (2,'A',16.67),
                        (3,'B',6.12),
                        (3,'C',2.78),
                        (3,'D',2.34),
                        (4,'D',21.29);
    
SELECT * FROM report;    

  
SELECT *
FROM report
WHERE dealer IN("A","C","D");

           
         
    
  

Related examples in the same category