Practical Mobile Forensics - Fourth Edition

Exploring standard SQL queries

In addition to the SQLite dot commands, standard SQL queries such as SELECT, INSERT, ALTER, and DELETE can be issued to SQLite databases on the command line. Unlike the SQLite dot commands, standard SQL queries expect a semicolon at the end of the command.

Most of the databases that you will examine will contain only a reasonable number of records, so you can issue a SELECT * statement, which prints all of the data contained in the table. This will be covered in detail throughout this chapter.