转自:http://bbs.csdn.net/topics/330170892 来自wwwwb的答案 自增可以不用写, insert into tt (f1,f2) select f1,f2 from tt