I know, MySQL supports BATCH INSERT
syntax like:
INSERT INTO `table_1` values(1, 2, 3), (3, 4, 5), (5, 6, 7);
Is this syntax included in SQL-92 format? If not, witch data bases support this syntax?
I know, MySQL supports BATCH INSERT
syntax like:
INSERT INTO `table_1` values(1, 2, 3), (3, 4, 5), (5, 6, 7);
Is this syntax included in SQL-92 format? If not, witch data bases support this syntax?
Copyright © 2021 Jogjafile Inc.
If you are concerned about portability, many databases support:
(Offhand, SQL Server, Postgres, MySQL, Teradata.)
And most of the rest support:
(Offhand, Oracle, MySQL)
Access and DB2 (offhand) don't support either of these syntaxes.