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 →