建视图吧,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(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(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