sqlite3命令行窗口常用命令
sqlite命令行窗口(Command Line Shell For sqlite)下，sqlite3的常用命令
这些命令均以 . 开头，所有命令如下表所示，最基本的几个命令已经加粗显示，适合初学者参考。当然你也可以请教最好的老师”.help” ^_^
| 命令 | 描述 |
|---|---|
| .backup ?DB? FILE | Backup DB (default “main”) to FILE |
| .bail on|off | Stop after hitting an error. Default OFF |
| .clone NEWDB | Clone data into NEWDB from the existing database |
| .databases | List names and files of attached databases |
| .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 |
| .indices ?TABLE? | Show names of all indices If TABLE specified,only show indices for tables matching LIKE pattern TABLE. |
| .log FILE|off | Turn logging on or off. FILE can be stderr/stdout |
| .mode MODE ?TABLE? | Set output mode where MODE is one of: csv Comma-separated values column Left-aligned columns. (See .width) html HTML < table > code insert sql insert statements for TABLE line One value per line list Values delimited by .separator string 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 |
| .schema ?TABLE? | Show the CREATE statements If TABLE specified,only show tables matching LIKE pattern TABLE. |
| .separator STRING ?NL? | Change separator used by output mode and .import NL is the end-of-line mark for CSV |
| .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” modeNegative values right-justify |
