CREAT TABLE TABLE_1
(
ID INT,
NAME VARCHAR(10),
COLUMN1 VARCHAR(10),
COLUMN2 VARCHAR(10),
COLUMN3 VARCHAR(10),
PRIMARY KEY (ID);
);INSERT INTO TABLE_1 (ID,NAME,COLUMN1,COLUMN2,COLUMN3) VALUES(1,”表名”,”属性1”,”属性2”,”属性3”);CREAT TABLE SELECT NAME FROM TABLE_1 WHERE ID=1
(
(SELECT COLUMN1 FROM TABLE_1 WHERE ID=1) VARCHAR(10),
(SELECT COLUMN2 FROM TABLE_1 WHERE ID=1) VARCHAR(10),
(SELECT COLUMN3 FROM TABLE_1 WHERE ID=1) VARCHAR(10),
);
大家帮忙看看这段代码有没有什么问题?
(
(SELECT COLUMN1 FROM TABLE_1 WHERE ID=1) VARCHAR(10),
(SELECT COLUMN2 FROM TABLE_1 WHERE ID=1) VARCHAR(10),
(SELECT COLUMN3 FROM TABLE_1 WHERE ID=1) VARCHAR(10),
);
是做什么用的?
真的是太智能了, 如果真能实现的话。 估计不能!!!!!!!!!!!!!!!!!!!