insert into tablename(字段1,字段2) values ("","") 即values里面的数据必须配对前面所给出的字段! insert into tablename select * from table2