菜鸟问题，急 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

菜鸟问题，急

菜鸟问题，急# Database - 数据库

M*72008-10-16 07:10

1 楼

请问下面这个QUERY为什么不WORK
SELECT *
INTO NewTable
FROM ( SELECT COL1,COL2 FROM Table1
UNION ALL
SELECT COL3,COL4 FROM Table2)
括号里的QUERY单独可以work。这里我如果想加order by 的话可以吗？
谢谢

n*62008-10-16 07:10

2 楼

SELECT COL1, COL2
INTO Newtable
FROM Table1
Prerequirement: Newtable does not exist. The process will automatic create
the new table.
I do not know if you can use
(SELECT * FROM Table1
UNION ALL
SELECT * FROM Table2)
INTO NewTable

【在 M***7 的大作中提到】

: 请问下面这个QUERY为什么不WORK
: SELECT *
: INTO NewTable
: FROM ( SELECT COL1,COL2 FROM Table1
: UNION ALL
: SELECT COL3,COL4 FROM Table2)
: 括号里的QUERY单独可以work。这里我如果想加order by 的话可以吗？
: 谢谢

B*g2008-10-16 07:10

3 楼

CREATE TABLE NewTable AS
SELECT *
FROM ( SELECT COL1,COL2 FROM Table1
UNION ALL
SELECT COL3,COL4 FROM Table2)
or
INSERT INTO NewTable
SELECT *
INTO NewTable
FROM ( SELECT COL1,COL2 FROM Table1
UNION ALL
SELECT COL3,COL4 FROM Table2)

【在 M***7 的大作中提到】

M*72008-10-16 07:10

4 楼

guys, thanks a lot .
Finally I used the following query
=====================
INSERT INTO NewTalbe
SELECT col1, col2 FROM TABLE1
UNION ALL
SELECT col3 col4 FROM TABLE2
======================
It woks.
If I use
=================
CREATE TABLE newtable AS
SELECT *
FROM (SELECT col1, col2 FROM TABLE1
UNION ALL
SELECT col3 col4 FROM TABLE2)
===================
It still did not work.
Could anyone explain it a little bit detail for me? I am really a rookie in
SQL.
Thanks.

B*g2008-10-16 07:10

5 楼

Create one will work if
1. you user oracle
2. NewTable does not exists

【在 M***7 的大作中提到】

: guys, thanks a lot .
: Finally I used the following query
: =====================
: INSERT INTO NewTalbe
: SELECT col1, col2 FROM TABLE1
: UNION ALL
: SELECT col3 col4 FROM TABLE2
: ======================
: It woks.
: If I use