SQLite Common Commands

1) Create the database file:

>sqlite3/home/test.db Enter

A test.db is generated under the/home path.

This also SQLite3 load the test.db

2) use. Help to see what the orders are.

>.help Enter

3) You can enter the SQL statement directly here to create the table

Sqlite> CREATE TABLE Company (

ID INT PRIMARY KEY not NULL,

NAME TEXT not NULL,
The age INT is not NULL,
ADDRESS CHAR (50),
SALARY REAL

);

4) See how many tables have been created

>.tables

5) Look at the table structure

>.schema Table Name

6) Look at the currently hanging database

>.database

7) If you want to output the query to a file

>.output/home/out.txt

> Query statements;

The query results are output to the file/home/out.txt

Use the screen output for query results

>.output stdout

8) Output The table structure, and the index will also output

. Dump Table Name

9) exit

>.exit or. Quit

SQLite Common Commands