Mysql copy a note

Mysql copies a record $ SQL = & quot; insertintotable1 (*) select * fromtable1whereid = $ id & quot; above is error 1. ID is automatically increased by 2. how can I complete copying all fields ., You need mysql to copy a record
$ SQL = "insert into table1 (*) select * from table1 where id = $ id ";


The above is incorrect.

1. automatically add ID
2. copy all fields

How can this problem be improved.

------ Solution --------------------
You need to list field names other than id
------ Solution --------------------
The copied field corresponds to your inser into tablename1 (a, B) select a, B from tablename
------ Solution --------------------
If you do not want to list fields manually, you can use the program
Because there is a primary key, it won't work if you don't list it.
What's more, mysql always recommends that you list the required fields to improve efficiency, instead of simply setting *
------ Solution --------------------
Similar to common writing, the field value must correspond