Hi,
I'm looking for an efficient SQL statement for copying a record.
Basically, I have a very complicated table that may change in the future, but I don't want to have to change this function every time it is. I want to feed it the id of a database record, and have one just like it be created.
So start as:
<U>ID, colA, colB, colC, colD</U>
1 , qwer, tyui, opas, dfghj
2 , zxcv, srdf, fghj, poik
run a function like
makeDuplicate (ID);
that calls a MySQL query THIS IS WHERE I NEED HELP
that makes the table look like:
<U>ID, colA, colB, colC, colD</U>
1 , qwer, tyui, opas, dfghj
2 , zxcv, srdf, fghj, poik
3 , qwer, tyui, opas, dfghj
Thanks for any help, in advance!
Jason