1.如果两张表结构相同的话 insert into A select * from B 2.如果表结构不同 insert into A (C1,C2........) SELECT (C1, C2.......) FROM B