SQLite operation guide (SQLite version 3.6.21)

1.. Back? DB? File backup dB (main by default) to file

2. Bail On | off: Stop when an error occurs. The default value is off.

3. Databases lists the database names and file names attached to the database.

4. Dump? Table? ... List databases in SQL text format. If a table is specified, only the matching tables, such as the type table

5. Echo on | off: Set the echo status to on or off.

6. Exit the program

7.. Explain? On | off? Set the output mode of explain to ON or OFF. If no parameter exists, explain is set to on by default.

8. genfkey? Options?

The options are as follows:

-- No-drop: indicates that the old fkey trigger is not deleted.

-- Ignore-errors: indicates to ignore tables with incorrect fkey.

-- Exec: indicates that the generated SQL statement is executed immediately.

View the tool/genfkey. readme file in the information source for more details.

9. Help show SQLite operation guide

10. Import file table indicates importing data to the table

11. indices? Table? Display All index names. If a table is specified, only the indexes of the specified table are displayed, such as the matching mode of the table.

12. Load file? Entry? Load an external library

13. Mode mode? Table? Set the output mode. The optional parameters are as follows:

CSV indicates comma-separated values

Column indicates the left column (see. width)

HTML indicates HTML-related code

Insert indicates the SQL insert statement of the table.

Line indicates a value for each row.

List indicates the value limited by the. Separator string

Tabs indicates tab-separated values

TCL indicates the Tcl list element

14. nullvalue string replacement of null value when printing

15. Output Filename transfers output to file name

16. Output stdout delivers output to the screen

17. Prompt main continue instead of standard prompt

18. Quit the program

19. Run the SQL statement in the file name of the. Read filename file.

20. Restore? DB? File: restores the database content from a file.

21. schema? Table? The create statement is displayed. If a table is specified, only the create statement of the table is specified.

22. The. Separator string changes the output mode and the Separator Used by. Import.

23. Show Displays the current values of different settings

24. tables? Table? Displays the table name. If a table is specified, only the table name of the specified table is displayed.

25,. Timeout MS try to open the table locked to Ms

26. Width numi num2 ...... Set the column width for "column" Mode

27.. timer on | off: Set the CPU time counter to on or off.

Note: Due to the limited level of English, translation errors are inevitable. Thank you ......