Michael Scharf wrote:
SQLite does not support the "row value constructors"
http://troels.arvin.dk/db/rdbms/#insert
INSERT INTO tablename
VALUES (0,'foo') , (1,'bar') , (2,'baz');
— which can be seen as a shorthand for
INSERT INTO tablename VALUES (0,'foo');
INSERT INTO tablename VALUES (1,'bar');
INSERT INTO tablename VALUES (2,'baz');
This could reduce the amount of parsing when
bulk-loading data from a file....
Using prepared statements with placeholders would reduce the amount of
parsing even further.
