How to duplicate a record in a table?

Question

MySQL

You need to duplicate records in one table. The table has a PRIMARY KEY(CODE) field.

Answer 1

I don't know why you would. But you can add another key field sequence or something like that

Answer 2

You need to change the primary key of the table to a surrogate key in sequence.
Then there will be no restrictions on entries.

Answer 3

INSERT INTO `tbl` (`col1`,`col2`...`colN`) SELECT `col1`,`col2`,...`colN` FROM `tbl` WHERE `code` = 123