Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Run multiple commands in sqlite manager

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

like image 569
leon22 Avatar asked Dec 02 '22 21:12

leon22


1 Answers

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);
...
like image 189
leon22 Avatar answered Dec 21 '22 14:12

leon22