A:
id country name
1 UK name1
2 UK name2
3 UK name3
4 CH name1现在想 通过一sql 把CH跟UK中不一样的name也插入,
结果如下:
id country name
1 UK name1
2 UK name2
3 UK name3
4 CH name1
2 CH name2
3 CH name3
id country name
1 UK name1
2 UK name2
3 UK name3
4 CH name1现在想 通过一sql 把CH跟UK中不一样的name也插入,
结果如下:
id country name
1 UK name1
2 UK name2
3 UK name3
4 CH name1
2 CH name2
3 CH name3
相应的增加
id country name
1 UK name1
2 UK name2
3 UK name3
4 CH name1
5 CH name2
6 CH name3
insert into tablename
select (select count(1) from tablename)+rownum,'CH',
tt.name
from tablename tt
group by 'CH',tt.name
having count(*) = 1;
没想到insert into
请问用select into 可否
中午就结贴
另外还有150分没人给答案,自己解决了
楼上两位或者给出select into 方法的 去回答下,我去给分
http://community.csdn.net/Expert/topic/5707/5707013.xml?temp=.6958277
http://community.csdn.net/Expert/topic/5718/5718650.xml?temp=.8876612