Hi, all,
I have a problem to convert table content based on existing content:
table: list:
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 2*2*2=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?
I have a problem to convert table content based on existing content:
table: list:
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 2*2*2=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?
Comment