General Command Summary of SQLite

1)

To create a database file:

>sqlite3 D:\test.db Enter

A test.db is generated on the D-disk.

And SQLite3 hung up on this test.db.

2)

Use. Help to see what the orders are.

>.help Enter

3) You can simply enter the SQL statement here to create a table, end it, and then enter to see the

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 file name

> Query statements;

The query results are output to the file C:\query.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

General Command Summary of SQLite