insert into test1 select user_id,notes from test; 或者在创建test1时: create table test1 as select user_id,notes from test;
老出错!发送了n次才发成功,csdn怎么了!
insert into test1(user_id,notes) select user_id,notes from test where not exists(select * from test1 where test1.user_id=test.user_id)
insert into test1(user_id,notes) select user_id,notes from test where not exists(select * from test1 where test1.user_id=test.user_id)
hehe,, zhoubf725(天上的鸟,怎能踢到) 成长是个过程而已,,
insert into test1 select user_id,notes from test;
如果你的表没有主键,那么用 insert into test1 select user_id,notes from test; 可以 如果表test1有主键为user_id, 那么你应该用下面的 insert into test1 (select distinct user_id,notes from test minus select user_id,notes from test1);================================================================ ★★ chen_cyh(逐波流) ●
如果你的表没有主键,那么用 insert into test1 select user_id,notes from test; 可以 如果表test1有主键为user_id, 那么你应该用下面的 insert into test1 (select distinct user_id,notes from test minus select user_id,notes from test1);================================================================ ★★ chen_cyh(逐波流) ●
select user_id,notes from test;
或者在创建test1时:
create table test1 as
select user_id,notes from test;
select user_id,notes
from test
where not exists(select * from test1 where test1.user_id=test.user_id)
select user_id,notes
from test
where not exists(select * from test1 where test1.user_id=test.user_id)
zhoubf725(天上的鸟,怎能踢到) 成长是个过程而已,,
insert into test1 select user_id,notes from test;
可以
如果表test1有主键为user_id,
那么你应该用下面的
insert into test1 (select distinct user_id,notes from test minus select user_id,notes from test1);================================================================
★★ chen_cyh(逐波流) ●
insert into test1 select user_id,notes from test;
可以
如果表test1有主键为user_id,
那么你应该用下面的
insert into test1 (select distinct user_id,notes from test minus select user_id,notes from test1);================================================================
★★ chen_cyh(逐波流) ●