firebird-automations
firebird-automations
Extend INSERT to support inserting multiple rows in single command (ala PostgreSQL/MySQL) [CORE1978]
Commented by: Gustavo Torres (gusta1308) I want an easy way for to send in one transaction multiples rows, around 500 rows or less\.
Extend INSERT to support inserting multiple rows in single command (ala PostgreSQL/MySQL) [CORE1978]
Commented by: @livius2 this is already implemented feature use execute block with many inserts example: execute block as insert into t\(a, b, c\) values\(1,2,3\); insert into t\(a, b, c\) values\(4,5,6\);...
Extend INSERT to support inserting multiple rows in single command (ala PostgreSQL/MySQL) [CORE1978]
Commented by: @dyemanov Karol, the requested multi\-value INSERT statement is a standard feature, so I believe the request is perfectly valid regardless of our EXECUTE BLOCK feature \(which can be...
Extend INSERT to support inserting multiple rows in single command (ala PostgreSQL/MySQL) [CORE1978]
Commented by: Sean Leyne (seanleyne) Edited the subject to correct terminology \(rows vs\. values\), clarify requirement \(single command vs\. complex SELECT UNION/Inline PSQL \[i\.e\. EXECUTE BLOCK solution\] as well as...
Extend INSERT to support inserting multiple rows in single command (ala PostgreSQL/MySQL) [CORE1978]
Modified by: Sean Leyne (seanleyne) description: I suggeste include Insert multi\-values INSERT INTO Table \(a, b, c\) values\(1, 2, 3\), \(4, 5, 6\) for improvement performance insert =\> I suggest...
Extend INSERT to support inserting multiple rows in single command (ala PostgreSQL/MySQL) [CORE1978]
Commented by: Eli Godoy (agamenon) I have 200\-250 fields, I need to put ALL fields in each insert?
Extend INSERT to support inserting multiple rows in single command (ala PostgreSQL/MySQL) [CORE1978]
Commented by: Stefan Heymann (stefanheymann) \> What's the point? A smaller command that has to go over the network\. Imagine you have a table with only one or two columns...
Extend INSERT to support inserting multiple rows in single command (ala PostgreSQL/MySQL) [CORE1978]
Commented by: Tommi Prami (mwaltari) I think this would be very good\. Less stuff top write when inserting from some text file etc\. No need to repeat INSERT INTO Table...
Extend INSERT to support inserting multiple rows in single command (ala PostgreSQL/MySQL) [CORE1978]
Modified by: @asfernandes assignee: Adriano dos Santos Fernandes \[ asfernandes \]
Extend INSERT to support inserting multiple rows in single command (ala PostgreSQL/MySQL) [CORE1978]
Commented by: @sim1984 It seems to me that this is part of another more general ticket [CORE3880](https://github.com/FirebirdSQL/firebird/issues?q=CORE3880+in%3Atitle)