sqlite version check

1select sqlite_version();
2

1sqlite> .help
2.archive ...             Manage SQL archives
3.auth ON|OFF             Show authorizer callbacks
4.backup ?DB? FILE        Backup DB (default "main") to FILE
5.bail on|off             Stop after hitting an error.  Default OFF
6.binary on|off           Turn binary output on or off.  Default OFF
7.cd DIRECTORY            Change the working directory to DIRECTORY
8.changes on|off          Show number of rows changed by SQL
9.check GLOB              Fail if output since .testcase does not match
10.clone NEWDB             Clone data into NEWDB from the existing database
11.databases               List names and files of attached databases
12.dbconfig ?op? ?val?     List or change sqlite3_db_config() options
13.dbinfo ?DB?             Show status information about the database
14.dump ?TABLE? ...        Render all database content as SQL
15.echo on|off             Turn command echo on or off
16.eqp on|off|full|...     Enable or disable automatic EXPLAIN QUERY PLAN
17.excel                   Display the output of next command in a spreadsheet
18.exit ?CODE?             Exit this program with return-code CODE
19.expert                  EXPERIMENTAL. Suggest indexes for specified queries
20.fullschema ?--indent?   Show schema and the content of sqlite_stat tables
21.headers on|off          Turn display of headers on or off
22.help ?-all? ?PATTERN?   Show help text for PATTERN
23.import FILE TABLE       Import data from FILE into TABLE
24.imposter INDEX TABLE    Create imposter table TABLE on index INDEX
25.indexes ?TABLE?         Show names of indexes
26.iotrace FILE            Enable I/O diagnostic logging to FILE
27.limit ?LIMIT? ?VAL?     Display or change the value of an SQLITE_LIMIT
28.lint OPTIONS            Report potential schema issues.
29.load FILE ?ENTRY?       Load an extension library
30.log FILE|off            Turn logging on or off.  FILE can be stderr/stdout
31.mode MODE ?TABLE?       Set output mode
32.nullvalue STRING        Use STRING in place of NULL values
33.once (-e|-x|FILE)       Output for the next SQL command only to FILE
34.open ?OPTIONS? ?FILE?   Close existing database and reopen FILE
35.output ?FILE?           Send output to FILE or stdout if FILE is omitted
36.parameter CMD ...       Manage SQL parameter bindings
37.print STRING...         Print literal STRING
38.progress N              Invoke progress handler after every N opcodes
39.prompt MAIN CONTINUE    Replace the standard prompts
40.quit                    Exit this program
41.read FILE               Read input from FILE
42.restore ?DB? FILE       Restore content of DB (default "main") from FILE
43.save FILE               Write in-memory database into FILE
44.scanstats on|off        Turn sqlite3_stmt_scanstatus() metrics on or off
45.schema ?PATTERN?        Show the CREATE statements matching PATTERN
46.selftest ?OPTIONS?      Run tests defined in the SELFTEST table
47.separator COL ?ROW?     Change the column and row separators
48.session ?NAME? CMD ...  Create or control sessions
49.sha3sum ...             Compute a SHA3 hash of database content
50.shell CMD ARGS...       Run CMD ARGS... in a system shell
51.show                    Show the current values for various settings
52.stats ?on|off?          Show stats or turn stats on or off
53.system CMD ARGS...      Run CMD ARGS... in a system shell
54.tables ?TABLE?          List names of tables matching LIKE pattern TABLE
55.testcase NAME           Begin redirecting output to 'testcase-out.txt'
56.timeout MS              Try opening locked tables for MS milliseconds
57.timer on|off            Turn SQL timer on or off
58.trace ?OPTIONS?         Output each SQL statement as it is run
59.vfsinfo ?AUX?           Information about the top-level VFS
60.vfslist                 List all available VFSes
61.vfsname ?AUX?           Print the name of the VFS stack
62.width NUM1 NUM2 ...     Set column widths for "column" mode
63sqlite>
64