一句INSERT如何写

skyone1981

想要完成一句INSERT语句,部分值是通过VALUES给出,部分使用SELECT给出,如何实现
inset into a,b,c,d
values('aaa','bbb',(select c,d from table_name);出错,
请高手解决.

macrodba

select aaa,bbb,c,d into table1 ;

peso

insert into a  
select  'aaaa','bbbb', c,d from   b  ;

caribe

少个右括号？

johnz02

Your thinking is not right.  values are separated by comma, (select c,d from tablename) gives two values, so is is wrong.
You may write:
  insert into tablenameA(a,b,c,d) values( 'aaa', 'bbb', (select c from table_nameB), (select d from table_nameB) from dual;

Make sure that select c from table_nameB returns only one value, add where clause if necessary.


John

syitssa

个人觉得不要用value这样写
建议^_^：
insert into tablenameA(a,b,c,d)
select 'aaa','bbb',c,d from table

北京野狼

原帖由 syitssa 于 2006-2-28 10:19 发表
个人觉得不要用value这样写
建议^_^：
insert into tablenameA(a,b,c,d)
select 'aaa','bbb',c,d from table

这个是对的

xc_hgm

4楼正解，如果c,d值不是唯一，要叫where条件。