k8s-mysql搭建
CREATE TABLE shop ( article INT(4) UNSIGNED ZEROFILL DEFAULT '0000' NOT NULL,dealerCHAR(20) DEFAULT '' NOT NULL,
price DOUBLE(16,2) DEFAULT '0.00' NOT NULL,
PRIMARY KEY(article, dealer));
INSERT INTO shop VALUES
(1,'A',3.45),(1,'B',3.99),(2,'A',10.99),(3,'B',1.45),(3,'C',1.69),
(3,'D',1.25),(4,'D',19.95);
好了，例子数据是这样的：
SELECT * FROM shop
+---------+--------+-------+
| article | dealer | price |
+---------+--------+-------+
| 0001 | A |3.45 |
| 0001 | B |3.99 |
| 0002 | A | 10.99 |
| 0003 | B |1.45 |
| 0003 | C |1.69 |
| 0003 | D |1.25 |
| 0004 | D | 19.95 |
+---------+--------+-------+
页:
[1]