iOS Data Analysis and Recovery - Practical Mobile Forensics - page 148

VALUES(7,'9951512182','in','SMS','9908923323');
COMMIT;
• .output file-name : This redirects the output to a file on the disk instead of
showing it on the screen.
• .headers on : This displays the column title whenever you issue a SELECT
statement.
• .help : This displays the list of available SQLite dot commands.
• .exit : This disconnects from the database and exits the SQLite command shell.
• .mode MODE : This sets the output mode where MODE can be csv, HTML, tabs,
and so on.
Tip
Make sure there is no space in between the SQLite prompt and the dot command, other-
wise the entire command will be ignored.