Oracle 11G 中的 INSERT SELECT 语句
我正在尝试在 Oracle 11g 中运行一个非常简单的 sql 语句.
I'm trying to run a very simple sql statement in Oracle 11g.
insert into table1 (col1, col2) values (select t1.col1, t2.col2 from oldtable1 t1, oldtable2 t2);
非常简单的查询.笛卡尔将旧表 1 连接到旧表 2，将结果值放入表 1.
Very simple query. Cartesian join old table 1 to old table 2, put the resulting values into table 1.
我自己运行了子查询，它运行良好.
I've run the subquery by itself, and it works perfectly.
select t1.col1, t2.col2 from oldtable1 t1, oldtable2 t2
当我尝试运行完整语句时，出现以下错误:
When I try to run the full statement, I get the following error:
SQL Error: ORA-00936: missing expression
00936. 00000 - "missing expression"
我也无法让它在 MySql 中工作.我的陈述有问题，但我不确定是什么.
I can't get it to work in MySql either. Something is wrong with my statement, but I'm not sure what it is.
推荐答案
您的查询应该是:
insert into table1 (col1, col2)
select t1.col1, t2.col2
from oldtable1 t1, oldtable2 t2
即没有 VALUES 部分.
相关文章