Duplicate / Copy records in the same MySQL table

by

The way that I usually go about it is using a temporary table. It’s probably not computationally efficient but it seems to work ok! Here i am duplicating record 99 in its entirety, creating record 100.

CREATE TEMPORARY TABLE tmp SELECT * FROM invoices WHERE id = 99;

UPDATE tmp SET id=100 WHERE id = 99;

INSERT INTO invoices SELECT * FROM tmp WHERE id = 100;

Hope that works ok for you!

More Related Contents:

  1. Should I use the datetime or timestamp data type in MySQL?
  2. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  3. MySQL string replace
  4. What is the difference between utf8mb4 and utf8 charsets in MySQL?
  5. How do I find the MySQL my.cnf location
  6. How do I get the current time zone of MySQL?
  7. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  8. MySQL select one column DISTINCT, with corresponding other columns
  9. How to use mysql JOIN without ON condition?
  10. How to get the difference in years from two different dates?
  11. ERROR: Error 1005: Can’t create table (errno: 121)
  12. Mysql Convert Column to row (Pivot table )
  13. Merge two tables in one SQL query and make the date values unique
  14. Writing optional parameters within stored procedures in MySQL? [duplicate]
  15. How to get all columns’ names for all the tables in MySQL?
  16. How do I get MySQL to use an INDEX for view query?
  17. Can I resolve this with pure mysql? (joining on ‘;’ separated values in a column)
  18. Restore the mysql database from .frm files
  19. Mysql insert random datetime in a given datetime range
  20. Greatest value of multiple columns with column name?
  21. insert data from one table to another in mysql
  22. MySQL UPDATE syntax with multiple tables using WHERE clause
  23. How does MySQL Auto Increment work?
  24. MySQL load data infile – acceleration?
  25. I keep getting this mysql error code #1089
  26. How to close sqlalchemy connection in MySQL
  27. How do I lock on an InnoDB row that doesn’t exist yet?
  28. MySQL Fulltext Search Score Explained
  29. MYSQL Select One Random record from each Category
  30. How to recover just deleted rows in mysql?

Leave a Comment