Search code examples
mysqlsqlpercona

Quickest way to duplicate a MySQL Record

Simple question, i have a query with some WHERE and i need to duplicate it with a change to 1 field to a different value? There is a unique increment ID field as well which I cannot duplicate.

Solution

  • Something along these lines should work. This will give you access to the row that you want to duplicate, and you just select the values to insert for the new row, replacing one of them.

    INSERT tblData
( -- Lets pretend Column1 is your key
   Column2
   , Column3
)
SELECT
   Column2
   , Column3 + 5 /*Replace this with whatever value is you want*/
FROM tblData
WHERE Column1 = @Id