insert tableB (cid, company, city , address, tel, linkman, homepage, email)
select cid, null, city, address, tel, null, null, null from tableA
select cid, null, city, address, tel, null, null, null from tableA
调试欢乐多
select cid,city,address,tel from tablea
select cid,city,address,tel from tablea
where cid not in(select cid from tableb)