INSERT INTO cgb_goods SELECT id+1,字段1,字段2...FROM cgb_goods ORDER BY id DESC LIMIT 1 注意:插入时主键id不能重复 也可复制多条,需注意插入时的字段,尤其是主键id