Hello everyone. Anyone knows the best way to duplicate entries in a database? New ID but same data. Thanks.
You can use PHP to make your job faster. first of all, you must have MySQL connections opened, then read the datas that you want to copy and store them to some variables. and then do a sql query that will insert the new datas (use the variables you stored before) in a loop depends on the total of the IDs that you wanted to create. also use the iteration as the new ID to avoid ID duplication.
If you know all fields are unique, add uniques to the table and use INSERT INTO ... ON DUPLICATE KEY so you never have duplicate data! check out mysql for more info about ON DUPLICATE KEY and UNIQUE indexes!