sql表内复制一条记录

INSERT INTO TABLE1 SELECT ID+1, COLUMN1, COLUMN2,... FROM TABLE1 WHERE ID=最大的ID 
原文地址:https://www.cnblogs.com/mumble/p/2324457.html