.bail on|off Stop after hitting an

.bail on|off Stop after hitting an error. Default OFF
.binary on|off Turn binary output on or off. Default OFF
.clone NEWDB Clone data into NEWDB from the existing database
.databases List names and files of attached databases
.dbinfo ?DB? Show status information about the database
.dump ?TABLE? ... Dump the database in an SQL text format
If TABLE specified, only dump tables matching
LIKE pattern TABLE.
.echo on|off Turn command echo on or off
.eqp on|off Enable or disable automatic EXPLAIN QUERY PLAN
.exit Exit this program
.explain ?on|off? Turn output mode suitable for EXPLAIN on or off.
With no args, it turns EXPLAIN on.
.fullschema Show schema and the content of sqlite_stat tables
.headers on|off Turn display of headers on or off
.help Show this message
.import FILE TABLE Import data from FILE into TABLE
.indexes ?TABLE? Show names of all indexes
If TABLE specified, only show indexes for tables
matching LIKE pattern TABLE.
.limit ?LIMIT? ?VAL? Display or change the value of an SQLITE_LIMIT
.load FILE ?ENTRY? Load an extension library
.log FILE|off Turn logging on or off. FILE can be stderr/stdout
.mode MODE ?TABLE? Set output mode where MODE is one of:
ascii Columns/rows delimited by 0x1F and 0x1E
csv Comma-separated values
column Left-aligned columns. (See .width)
html HTML code
insert SQL insert statements for TABLE
line One value per line
list Values delimited by .separator strings
tabs Tab-separated values
tcl TCL list elements
.nullvalue STRING Use STRING in place of NULL values
.once FILENAME Output for the next SQL command only to FILENAME
.open ?FILENAME? Close existing database and reopen FILENAME
.output ?FILENAME? Send output to FILENAME or stdout
.print STRING... Print literal STRING
.prompt MAIN CONTINUE Replace the standard prompts
.quit Exit this program
.read FILENAME Execute SQL in FILENAME
.restore ?DB? FILE Restore content of DB (default "main") from FILE
.save FILE Write in-memory database into FILE
.scanstats on|off Turn sqlite3_stmt_scanstatus() metrics on or off
.schema ?TABLE? Show the CREATE statements
If TABLE specified, only show tables matching
LIKE pattern TABLE.
.separator COL ?ROW? Change the column separator and optionally the row
separator for both the output mode and .import
.shell CMD ARGS... Run CMD ARGS... in a system shell
.show Show the current values for various settings
.stats on|off Turn stats on or off
.system CMD ARGS... Run CMD ARGS... in a system shell
.tables ?TABLE? List names of tables
If TABLE specified, only list tables matching
LIKE pattern TABLE.
.timeout MS Try opening locked tables for MS milliseconds
.timer on|off Turn SQL timer on or off
.trace FILE|off Output each SQL statement as it is run
.vfsname ?AUX? Print the name of the VFS stack
.width NUM1 NUM2 ... Set column widths for "column" mode
Negative values right-justify

Kết quả (Anh) 1:

bail off Stop |. after hitting an error. Default OFF. binary on | off Turn binary output on or off. Default OFFClone data into NEWDB NEWDB. clone from the existing database... databases List names and files of attached databasesdbinfo.? DB? Show status information about the database. dump? TABLE? ... Dump the database in an SQL text format If the TABLE specified, only dump tables matching LIKE pattern TABLE.Turn off command | echo. echo on or off. eqp on | off Enable or disable automatic EXPLAIN QUERY PLAN. exit Exit this program... explain? on | off? Turn output mode suitable for EXPLAIN on or off. With no args, EXPLAIN it turns on.. fullschema-Show schema and the content of sqlite_stat tables. headers on | off Turn display of headers on or off. help Show this messageTABLE Import data from FILE to import. FILE into TABLE. indexes? TABLE? Show names of all indexes If the TABLE specified, only show indexes for tables matching LIKE pattern TABLE.. limit? LIMIT?? VAL? Display or change the value of an SQLITE_LIMIT. load FILE? ENTRY? Load an extension library. log FILE logging Turn off | on or off. The FILE can be stderr/stdoutmode MODE? TABLE? Set output mode where MODE is one of: ASCII Columns/rows delimited by 0x1F and 0x1E CSV Comma-separated values column Left-aligned columns. (See. width) HTML HTML code Insert SQL insert statements for TABLE line One value per line list Values delimited by separator strings. tabs with Tab-separated values Tcl TCL list elementsnullvalue STRING Use STRING. in place of NULL values... once the next SQL command Output for the FILENAME only to FILENAME... open? FILENAME? Close existing database and reopen FILENAME. output? FILENAME? Send output to FILENAME or stdout... print STRING ... Print literal STRING. prompt MAIN CONTINUE Replace the standard prompts. quit Exit this programread FILENAME Execute SQL in FILENAME... restore? DB? FILE Restore content of DB (default "main") from FILE. save FILE Write in-memory database into FILE. sqlite3_stmt_scanstatus Turn off | scanstats () metrics on or off. schema? TABLE? Show the CREATE statements If the TABLE specified, only show tables matching LIKE pattern TABLE.... separator COL? ROW? Change the column separator and optionally the row separator for both the output mode and import.. shell CMD ARGS ... Run CMD ARGS ... in a system shell.-show Show the current values for various settings... stats | off Turn stats on or offCMD ARGS ... system. Run CMD ARGS ... in a system shell. tables? TABLE? List names of tables If the TABLE specified, only list tables matching LIKE pattern TABLE.MS Try opening locked timeout. tables for MS millisecondsTurn off SQL | timer. timer on or off. trace FILE | off Output each SQL statement as it is run. vfsname? AUX? Print the name of the VFS stackNUM1 NUM2 ... width. Set column widths for "column" mode Negative values right-justify

Kết quả (Anh) 2:

.bail on | off Stop after hitting an error. Default OFF
.binary on | off Turn on or off binary output. Default OFF
.clone newdb Into Clone data from the existing database newdb
.databases List names and files of attached databases
.dbinfo? DB? Show status information about the database
.dump? TABLE? ... Dump the database in an SQL text format
If TABLE rõ, only matching tables dump
TABLE LIKE pattern.
.echo On | off Turn command echo on or off
.eqp on | off Enable or disable automatic EXPLAIN PLAN QUERY
Exit this .exit program
.explain? on | off? Turn output mode suitable for EXPLAIN on or off.
With no args, it turns EXPLAIN on.
.fullschema Show schema and the content of sqlite_stat tables
.headers on | off Turn on or off the display of headers
.help Show this message
FILE TABLE .import Import data from FILE INTO TABLE
.indexes? TABLE? Show names of all indexes
If TABLE rõ, indexes for tables show only
matching TABLE LIKE pattern.
.limit? LIMIT? ? VAL? Display or change the value of an SQLITE_LIMIT
.load FILE? ENTRY? Load an extension library
.log FILE | off Turn logging on or off. FILE can be stderr / stdout
.mode MODE? TABLE? Set output mode where MODE is one of:
ascii Columns / rows delimited by 0x1F and 0x1E
csv Comma-separated values
​​column Left-aligned columns. (See .width)
html HTML code
insert SQL insert statements for TABLE
line One value per line
list Values ​​.separator strings delimited by
tabs, tab-separated values
​​tcl TCL list elements
.nullvalue STRING STRING Use in place of NULL values
​​Output for .once FILENAME the next SQL command only to FILENAME
.open? FILENAME? Close and reopen existing database FILENAME
.output? FILENAME? Send output to FILENAME or stdout
.print Print literal STRING STRING ...
MAIN CONTINUE Replace the standard .prompt prompts
.quit Exit this program
Execute SQL in FILENAME FILENAME .read
.restore? DB? FILE Restore content of DB (default "main") from FILE
FILE .save in-memory database Write Into FILE
.scanstats on | off Turn sqlite3_stmt_scanstatus () metrics on or off
.schema? TABLE? Show the statements CREATE
TABLE If rõ, matching tables only show
TABLE LIKE pattern.
.separator COL? ROW? Change the column separator and tùy the row
separator for the output mode and .import cả
.shell CMD ARGS ... Run CMD ARGS ... in a system shell
.show Show the current values ​​for various settings
.stats on | off Turn stats on or off
.system CMD ARGS ... Run CMD ARGS ... in a system shell
.tables? TABLE? List names of tables
TABLE If rõ, only list matching tables
TABLE LIKE pattern.
.timeout Try opening MS locked tables for MS milliseconds
.timer on | off Turn on or off timer SQL
.trace FILE | off Output SQL statement as it is each tremor
.vfsname? AUX? Print the name of the VFS stack
.width NUM1 Widths NUM2 ... Set column for "column" mode
right-justify Negative values