| Subject | Re: [firebird-support] Insert multiple rows with one Execute ? |
|---|---|
| Author | Helen Borrie |
| Post date | 2005-08-24T23:21:34Z |
At 06:11 PM 24/08/2005 +0000, you wrote:
insert into atable (<input list>)
select <exactly-mapped-list>
from <tables>
If you are wanting to insert data from an external source, a server-based
text file with fixed length records, you can set the file up as an external
table and use this syntax to load the data into your real table.
./heLen
>Is there a way you can insert multiple rows with a single executeIt depends on where the data is coming from. You can do
>call ? I know you can use the same prepared statement, set different
>bind values and execute everytime but this is going to take N
>roundtrips to the server to insert N rows. Is there a better way ?
insert into atable (<input list>)
select <exactly-mapped-list>
from <tables>
If you are wanting to insert data from an external source, a server-based
text file with fixed length records, you can set the file up as an external
table and use this syntax to load the data into your real table.
./heLen