34,575
社区成员
发帖
与我相关
我的任务
分享
请大侠指点指点,是不是不能这样create table呀,那要是我想用一个查询的结果create a table,我该怎么办呢?
create table aaa
as select * from bbb;
0)See structure of TestTmp
SELECT * FROM TestTmp WHERE 1 = 3
test
--------------------
(0 row(s) affected)
1)Copy column(s) from TestTmp without data involved to new table AAA
SELECT * INTO AAA FROM TestTmp WHERE 1 = 3 -- 1 = 1
2)Test AAA's structure
SELECT * FROM AAA WHERE 1 = 3
test
--------------------
(0 row(s) affected)
select * INTO AAA from bbb;
CREATE TABLE TB1(I INT)
INSERT TB1 SELECT 1
SELECT * INTO TB2 FROM TB1
SELECT * FROM TB2
I
-----------
1
(1 行受影响)
select * INTO AAA from bbb;