insert into b select * from a
假设A表和B表中的字段为:Field1,Field2,Fieldn,其中,Field1为主键,可以采用以下SQL语句从B表中追加A表中没有的数据到A表:INSERT INTO A(Field1,Field2,Fieldn) SELECT Field1,Field2,Fieldn FROM B WHERE B.Field1<>A.Field1