6 ms·
Nice. Works in sqlite3 - but it doesn’t like the parens around the tablename. $ cat multiple-insert.sql create table users (first, last); insert into use
by emmelaich 7y ago
Nice. Works in sqlite3 - but it doesn’t like the parens around the tablename.
$ cat multiple-insert.sql
create table users (first, last);
insert into users values ('fred','bloggs'), ('mary', ‘contrary');
select * from users;
$ sqlite3 < multiple-insert.sql
fred|bloggs
mary|contrary