Sqlite3.exe Using Tutorials

Sqlite3.exe Using Tutorials

1). Open the Database

Example:

sqlite>. Open Test.db

Note that:> is a little behind

2). Tables view the tables contained in the database

Example:

Sqlite>. Tables

Note that:> is a little behind

3). Schema View table structure

Example:

Sqlite>. Schema students

Note that:> is a little behind

4) Execute SQL statement

Example:

Sqlite> SELECT * from students where StudentID = 3;

Note: You can set the result format of the output before calling SQL

-Displays the column name of the select result set.

--Displays the individual fields as columns.

--Set the display width of the first column after output to 10.

Sqlite>. Header on

sqlite>. Mode column

sqlite>. Width 10

5). Exit exits

Sqlite3.exe Using Tutorials