I need to create some nearly identical copies of rows in a complicated table.
Is there a handy syntax that would let me copy a existing row, but get a new primary key for the copy? I'd then go in an edit the 1 or 2 additional columns that differ. The duplicate would be in the same table as the original. This would save me a bunch of typing. Can it be done? ---- Visit http://www.obviously.com/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
