|Subject||RE: [firebird-support] Duplicate a set of records|
|Author||Svein Erling Tysvær|
>FB 1.5Hi Ed!
>I have a number of records in a table, that includes a BLOB field, that I need to duplicate.
>Is there an easy way of doing that?
This question may be understood very differently. If you want to exactly duplicate the records, I don't know how to do that. If you want to duplicate the records, except the primary key, then do:
INSERT INTO MyTable(Field1, Field2...)
SELECT Field1, Field2...
WHERE PK IN (...) //Alternatively, where PK < ... or similar
If you generally want the value of one field duplicated to another field or another table, then I'd recommend using a trigger.
If you're looking for something different, then please clarify your question.