January 2018
Beginner to intermediate
402 pages
10h 6m
English
book
Practical Mobile Forensics - Third Edition
by Rohit Tamma, Oleg Skulkin, Heather Mahalik, Satish Bommisetty
Content preview from Practical Mobile Forensics - Third Edition
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Standard SQL queries
In addition to the SQLite dot commands, standard SQL queries, such as SELECT, INSERT, ALTER, DELETE, and more, 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 outputs all of the data contained in the table. This will be covered in detail throughout this chapter.