It's possible to run more than one command in the direct SQL execution in SQlite Manager? (useful if you insert a lot of data)
e.g.
insert into TestTable (Name, Age) values("Thomas", 25)
insert into TestTable (Name, Age) values("Peter", 29)
...
Thx
Solution is very simple ;-)
-> use a semicolon to separate the commands
insert into TestTable (Name, Age) values("Thomas", 25);
insert into TestTable (Name, Age) values("Peter", 29);
...
Alternatively, you could write the statement as:
insert into TestTable (Name, Age)
values
("Thomas", 25),
("Peter", 29)
;
Edit: Please note, as per @DominiqueJacquel's comment, that this will only work in SQLite version 3.7.11+
Perhaps you may work executemany() method instead of execute()
Something like:
values = [
("Thomas", 25),
("Peter", 29)
]
conn.executemany("insert into TestTable (Name, Age) values (?, ?)", values)
Will work fine.
Create a file like:
$ cat query-list.sql
insert into TestTable (Name, Age) values("Thomas", 25)
insert into TestTable (Name, Age) values("Peter", 29)
...
Now run the command:
$ sqlite3 my-database.db < query-list.sql
