Search code examples
sqldatabasesqlitesqlitemanager

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


Solution

  • 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);
    ...