Hi, all,
I have a problem to convert table content based on existing content:
DROP TABLE IF EXISTS list;
CREATE TABLE list (
FACILITY varchar(30) NOT NULL,
PRODUCT varchar(30) NOT NULL,
SEGMENT varchar(30) NOT NULL,
PRIMARY KEY (FACILITY,PRODUCT,SEGMENT)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Let’s say I know,
I have 2 FACILITY: AUSTIN, BOSTON;
(by
select distinct facility from list;
)
I have 2 PRODUCT: A, B;
(by
select distinct product from list;
)
I have 2 SEGMENT: BIG, SMALL;
(by
select distinct segment from list;
)
the Total combination could be 222=8
Now the current table “list” contains below data (3 records):
AUSTIN, A, BIG;
AUSTIN, B, SMALL;
BOSTON, A, SMALL;
How can I tell the other 5 combination by MYSQL?