第一种:
insert into destTbl select * from srcTbl;
第二种:
insert into destTbl(col1, col2, ..., coln) select col1, col2, ..., coln from srcTbl;
第一种:
insert into destTbl select * from srcTbl;
第二种:
insert into destTbl(col1, col2, ..., coln) select col1, col2, ..., coln from srcTbl;