复制表的信息到另一个表中 将学生信息student表中的信息复制到people表中 insert into people (id,name,age) select b.id,b.name,b.age from students b (people表中不存在ide的信息) insert into people (id,name,age) select b.id,b.name,b.age from students b where id not in(select id from people);