.\" Hey, EMACS: -*- nroff -*-.\" First parameter, NAME, should be all caps.\" Second parameter, SECTION, should be 1-8, maybe w/ subsection.\" other parameters are allowed: see man(7), man(1).TH SQLITE3 1 "Fri Aug 11 23:50:12 CET 2023".\" Please adjust this date whenever revising the manpage..\".\" Some roff macros, for reference:.\" .nh disable hyphenation.\" .hy enable hyphenation.\" .ad l left justify.\" .ad b justify to both left and right margins.\" .nf disable filling.\" .fi enable filling.\" .br insert line break.\" .sp <n> insert n+1 empty lines.\" for manpage-specific macros, see man(7).SH NAME.B sqlite3\- A command line interface for SQLite version 3.SH SYNOPSIS.B sqlite3.RI [ options ].RI [ databasefile ].RI [ SQL ].SH SUMMARY.PP.B sqlite3is a terminal-based front-end to the SQLite library that can evaluatequeries interactively and display the results in multiple formats..B sqlite3can also be used within shell scripts and other applications to providebatch processing features..SH DESCRIPTIONTo start a.B sqlite3interactive session, invoke the.B sqlite3command and optionally provide the name of a database file. If thedatabase file does not exist, it will be created. If the database filedoes exist, it will be opened.For example, to create a new database file named "mydata.db", createa table named "memos" and insert a couple of records into that table:.sp$.B sqlite3 mydata.db.brSQLite version 3.43.0 2023年08月11日 17:45:23.brEnter ".help" for usage hints..brsqlite>.B create table memos(text, priority INTEGER);.brsqlite>.B insert into memos values('deliver project description', 10);.brsqlite>.B insert into memos values('lunch with Christine', 100);.brsqlite>.B select * from memos;.brdeliver project description|10.brlunch with Christine|100.brsqlite>.spIf no database name is supplied, the ATTACH sql command can be usedto attach to existing or create new database files. ATTACH can alsobe used to attach to multiple databases within the same interactivesession. This is useful for migrating data between databases,possibly changing the schema along the way.Optionally, a SQL statement or set of SQL statements can be supplied asa single argument. Multiple statements should be separated bysemi-colons.For example:.sp$.B sqlite3 -line mydata.db 'select * from memos where priority > 20;'.brtext = lunch with Christine.brpriority = 100.br.sp.SS SQLITE META-COMMANDS.PPThe interactive interpreter offers a set of meta-commands that can beused to control the output format, examine the currently attacheddatabase files, or perform administrative operations upon theattached databases (such as rebuilding indices). Meta-commands arealways prefixed with a dot (.).A list of available meta-commands can be viewed at any time by issuingthe '.help' command. For example:.spsqlite>.B .help.nf.tr %.....sp.fiThe available commands differ by version and build options, so theyare not listed here. Please refer to your local copy for all availableoptions..SH INIT FILE.B sqlite3reads an initialization file to set the configuration of theinteractive environment. Throughout initialization, any previouslyspecified setting can be overridden. The sequence of initialization isas follows:o The default configuration is established as follows:.sp.nf.cc |mode = LISTseparator = "|"main prompt = "sqlite> "continue prompt = " ...> "|cc ..sp.fio If the file.B ${XDG_CONFIG_HOME}/sqlite3/sqlitercor.B ~/.sqlitercexists, the first of those to be found is processed during startup.It should generally only contain meta-commands.o If the -init option is present, the specified file is processed.o All other command line options are processed..SH SEE ALSOhttps://sqlite.org/cli.html.brhttps://sqlite.org/fiddle (a WebAssembly build of the CLI app).brThe sqlite3-doc package..SH AUTHORThis manual page was originally written by Andreas Rottmann<rotty@debian.org>, for the Debian GNU/Linux system (but may be usedby others). It was subsequently revised by Bill Bumgarner <bbum@mac.com>,Laszlo Boszormenyi <gcs@debian.hu>, and the sqlite3 developers.
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。