Subject | Re: [firebird-support] Inserting Rows into DB |
---|---|
Author | Ivan Prenosil |
Post date | 2006-05-17T07:02:13Z |
> Is there some syntaxWith FB2 there is one possibility:
> to build multiple VALUES list entries and insert them with one execute
> statement I can research further?
EXECUTE BLOCK AS
BEGIN
INSERT INTO tab(a) VALUES (10);
INSERT INTO tab(a) VALUES (20);
INSERT INTO tab(a) VALUES (30);
INSERT INTO tab(a) VALUES (40);
INSERT INTO tab(a) VALUES (50);
END
It is executed as single command so it reduces network traffic,
otoh it does not take advantage of using prepared statements.
Ivan
http://www.volny.cz/iprenosil/interbase/