insert into hyzc(id,name,password,xingming,sex,card,email,tel,post,address,tishi.daan,date) select id,name,password,xingming,sex,card,email,tel,post,address,tishi.daan,date from hyzc1 union all select id,name,password,xingming,sex,card,email,tel,post,address,tishi.daan,date from hyzc2
insert into hyzc select * from hyzc1 union all select * from hyzc2
网速太慢!:) insert into hyzc select * from hyzc1 union all select * from hyzc2
建视图吧,CREATE VIEW VW_hyzc AS select id,name,password,xingming,sex,card,email,tel,post,address,tishi.daan,date from hyzc union select id,name,password,xingming,sex,card,email,tel,post,address,tishi.daan,date from hyzc1 union select id,name,password,xingming,sex,card,email,tel,post,address,tishi.daan,date from hyzc2 调用 VW_hyzc 就可以了。 试一试
insert into hyzc select * from hyzc1 union all select * from hyzc2 go 不是很简单好用了吗?
Access~~insert into hyzc select * from (select * from hyzc1 union all select * from hyzc2 ) a
insert into hyzc(name,password,xingming,sex,card,email,tel,post,address,tishi.daan,date) select name,password,xingming,sex,card,email,tel,post,address,tishi.daan,date from (select name,password,xingming,sex,card,email,tel,post,address,tishi.daan,date from hyzc1 union all select name,password,xingming,sex,card,email,tel,post,address,tishi.daan,date from hyzc2 ) a
select id,name,password,xingming,sex,card,email,tel,post,address,tishi.daan,date from hyzc1
union all
select id,name,password,xingming,sex,card,email,tel,post,address,tishi.daan,date from hyzc2
select * from hyzc1
union all
select * from hyzc2
insert into hyzc
select * from hyzc1
union all
select * from hyzc2
2楼是将hyzc1,hyzc2的所有数据合并后存入hyzc,没有1楼的问题
3楼将hyzc1,hyzc2的所有数据合并后存入hyzc,和1楼存在一样问题
4楼什么也没说:)
select id,name,password,xingming,sex,card,email,tel,post,address,tishi.daan,date from hyzc
union
select id,name,password,xingming,sex,card,email,tel,post,address,tishi.daan,date from hyzc1
union
select id,name,password,xingming,sex,card,email,tel,post,address,tishi.daan,date from hyzc2
调用 VW_hyzc 就可以了。
试一试
select * from hyzc1
union all
select * from hyzc2
go
不是很简单好用了吗?
select * from
(select * from hyzc1
union all
select * from hyzc2
) a
select name,password,xingming,sex,card,email,tel,post,address,tishi.daan,date from
(select name,password,xingming,sex,card,email,tel,post,address,tishi.daan,date from hyzc1
union all
select name,password,xingming,sex,card,email,tel,post,address,tishi.daan,date from hyzc2
) a