Oracle 11G 中的 INSERT SELECT 语句

2021-12-06 00:00:00 sql oracle11g oracle

我正在尝试在 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 部分.

相关文章