我在下面有'data'
个表,其中'INITIAL','BETWIXT','ENDING'
列插入了值;
SET SQL_SAFE_UPDATES = 0;
CREATE TABLE data (
INITIAL INT NOT NULL,
BETWIXT INT NOT NULL,
ENDING VARCHAR(20)
);
INSERT
INTO data(data.INITIAL,data.BETWIXT,data.ENDING)
VALUES
(30,40,"N0"),
(60,80,"N1"),
(90,120,"N2"),
(120,160,"N3"),
(150,200,"N4");
SELECT DISTINCT ENDING AS "HI"
FROM data
WHERE data.INITIAL BETWEEN 60 AND 150;
但我正在接近将"HI"虚拟列插入到主表"data"中,以便将其可视化为
INITIAL BETWIXT ENDING HI
30 40 N0 N1
60 80 N1 N2
90 120 N2 N3
120 160 N3 N4
150 200 N4
如何编写代码来构造上述内容,而不仅仅是单个虚拟列?.