MySQL copy a single record

MySQL Copy a record
$sql = "INSERT INTO table1 (*) SELECT * FROM table1 where id= $id";


The above is wrong.

1.ID Auto Increase
2. Copy all field contents

Ask how to perfect.

------Solution--------------------
You need to list field names other than the ID
------Solution--------------------
The copied fields correspond to your inser into tablename1 (A, A, a, b) select a, from tablename
------Solution--------------------
If you do not want to manually list the fields, you can use the program to
Because of the primary key, not listed is not possible
Not to mention MySQL has always suggested: to improve efficiency, please list the required fields, not simple *
------Solution--------------------
As you normally write, you must correspond to the field values

