Subject | RE: [firebird-support] INSERT Multiple Rows same SQL Statment |
---|---|
Author | Sasha Matijasic |
Post date | 2008-09-24T15:15:54Z |
>I think it's easier like this:
> something like
>
> execute block as (
> insert on _table_ (field1,field2,field3,field4) values ('USD', 'EUR',
> 2008,0.93);
> insert on _table_ (field1,field2,field3,field4) values ('BLR', 'AUD',
> 2007,x.xx);
> ...
> )^
>
> (this is not the correct syntax, look at the release notes)
>
> Note that "old" FB versions do not suport execute block.
>
insert into table_ (field1, field2)
select val1_1, val2_1 from rdb$database union all
...
select val1_2, val2_2 from rdb$database;
And as far as i know, firebird supports this since ever (didn't test it though).
Sasha