|
/*
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");
|