|Subject||Re: [firebird-support] Which way is best...|
> According to my earlier postings, I would like to know which way is best.Another possibility would be:
> I have a table, containing some 4 mill. records.
> Each records has several varchars, date, numeric and integer fields.
> I have to insert around 300.000 more, which will be almost identical
> to some other 300.000 except for 1 field.
> What I do now is
> Fields I need
> from table
> some condition
> Then I iterate through to dataset and insert 1 record for each record.
> How do I do that the best way ?
insert in mytable ( columns ... )
values select columns, myother_value
where <make sure it doesn't select rows you're inserting, this is a Firebird
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Database development questions? Check the forum!