SQLITE3(1) SQLITE3(1) (NAME) sqlite3 - SQLite 3 (SYNOPSIS) sqlite3 [] [_] [SQL] (SUMMARY) sqlite3 SQLite . sqlite3 . (DESCRIPTION) sqlite3 SQL SQLite . sqlite3 sqlite3 . . . "mydata.db" "memos" : $ sqlite3 mydata.db SQLite version 3.8.8 Enter ".help" for instructions sqlite> create table memos(text, priority INTEGER); sqlite> insert into memos values('deliver project description', 10); sqlite> insert into memos values('lunch with Christine', 100); sqlite> select * from memos; deliver project description|10 lunch with Christine|100 sqlite> SQL ATTACH . ATTACH . () . SQL SQL . - (;) . : $ sqlite3 -line mydata.db 'select * from memos where priority > 20;' text = lunch with Christine priority = 100 SQLITE (SQLITE META-COMMANDS) (meta-commands) ( ) . (.) . '.help' . : sqlite> .help .backup ?DB? FILE DB ( "main") FILE .bail on|off . OFF .clone NEWDB NEWDB .databases .dump ?TABLE? ... SQL TABLE LIKE . .echo on|off .eqp on|off EXPLAIN QUERY PLAN .exit .explain ?on|off? EXPLAIN. EXPLAIN . .fullschema sqlite_stat .headers on|off .help .import FILE TABLE FILE TABLE .indices ?TABLE? TABLE LIKE . .load FILE ?ENTRY? .log FILE|off . FILE stderr/stdout .mode MODE ?TABLE? MODE : csv column ( .width ) html HTML insert SQL TABLE line list .separator tabs tcl TCL .nullvalue STRING STRING NULL .once FILENAME SQL FILENAME .open ?FILENAME? FILENAME .output ?FILENAME? FILENAME stdout .print STRING... STRING .prompt MAIN CONTINUE .quit .read FILENAME SQL FILENAME .restore ?DB? FILE DB ( "main") FILE .save FILE FILE .schema ?TABLE? CREATE TABLE LIKE . .separator STRING ?NL? .import NL CSV .shell CMD ARGS... CMD ARGS... .show .stats on|off .system CMD ARGS... CMD ARGS... .tables ?TABLE? TABLE LIKE . .timeout MS MS .timer on|off SQL .trace FILE|off SQL .vfsname ?AUX? VFS .width NUM1 NUM2 ... "column" sqlite> (OPTIONS) sqlite3 : -bail . -batch /. -column . -cmd command command (stdin). -csv CSV (). -echo . -init file file SQL . -[no]header . -help . -html HTML . -interactive /. -line . . -list ( |) . . -mmap N mmap N. -nullvalue string NULL. '' () . -separator separator . '|' . -stats (finalize). -version SQLite. -vfs name name (VFS) . (INIT FILE) sqlite3 . . : o : mode = LIST separator = "|" main prompt = "sqlite> " continue prompt = " ...> " o ~/.sqliterc . . o -init. o . (SEE ALSO) http://www.sqlite.org/cli.html sqlite3-doc. (AUTHORS) Andreas Rottmann / ( ). Bill Bumgarner Laszlo Boszormenyi . sqlite SQLITE3(1)