Can anyone tell me how I can duplicate a table entry updating one field without extracting all the data from one entry and insert it into a new one?
ie
A table with one row:
id A B C D E F...
1 aa bb cc dd ee ff...
How to add another row like this:
2 aa bb cc dd ee ff...
The problem with extracting data and inserting it into a new row is that I have quite alot of fields..
