SQLite - INSERT multiple row simultaneously

How to INSERT multiple row simultaneously in SQLite?

You can use UNION in the statement:

INSERT INTO 'table_name'
SELECT
	'data1_1' AS 'column1',
	'data2_1' AS 'column2'
UNION ALL
SELECT
	'data1_2',
	'data2_2'
UNION ALL
SELECT
	'data1_3',
	'data2_3'
UNION ALL
SELECT
	'data1_4',
	'data2_4';

Or you can run this:

BEGIN TRANSACTION;
INSERT INTO 'table_name' TABLE
		VALUES('data1_1', 'data2_1');
INSERT INTO 'table_name' TABLE
		VALUES('data1_2', 'data2_2');
INSERT INTO 'table_name' TABLE
		VALUES('data1_3', 'data1_3');
INSERT INTO 'table_name' TABLE
		VALUES('data1_4', 'data2_4');
COMMIT;

---

Need a good GUI tool for SQLite? Check out TablePlus. It’s native, beautiful, and available for free.

Download TablePlus for Mac.

Not on Mac? Download TablePlus for Windows.

On Linux? Download TablePlus for Linux

Need a quick edit on the go? Download TablePlus for iOS.