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)