Pong

June 20th 2014, SQLite CLI

June 18th 2014 QSqlDatabase | | June 21th 2014 SQLite Statements

SQLite comes with a command line interface (CLI). Using that interface it is pretty easy to manipulate or dump SQLite databases. Just start the CLI with the database file as argument:

> sqlite3 ~/db.sqlite

Then enter SQL statements directly on the command line or use prepared statements, which start with a “.”. For example, to dump a table, we use the prepared SQL statement “.dump”:

sqlite> .dump table 

To exit the CLI, hit Ctrl-D.

More on the CLI at http://www.sqlite.org/cli.html.

June 18th 2014 QSqlDatabase | | June 21th 2014 SQLite Statements

Options: