insert into table1 (cid, name,age) //要导入数据的表 select newid() , a.名称 as name ,a.年龄 as age from table2 a // 原数据表