Information Technology Reference
In-Depth Information
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. Un-
like the SQLite dot commands, the standard SQL queries expect a semicolon at the end of
the command.
Most of the databases 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.
The following example displays the values in the
handle
table, which is found inside the
sms.db
database:
sqlite> select * from handle limit 1;
7|9951512182|in|SMS|9908923323
