SQLITE入门 逐步讲解SQLITE命令行(二)
可以接着上一步操作，直接向DOS窗口输入.help命令来查看SQLite的所有命令行及解释如下：
F:\>sqlite3
SQLite version 3.6.16
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .help
也可以ctrl+c结束命令，想DOS窗口 输入sqlite3执行后再输入.help命令如下：
F:\>sqlite3
SQLite version 3.6.16
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .help
显示如下:
.backup ?DB? FILE
Backup DB (default "main") to FILE
.bail ON|OFF
Stop after hitting an error. Default OFF
.databases
List names and files of attached databases
.dump ?TABLE? ...
Dump the database in an SQL text format
.echo ON|OFF
Turn command echo on or off
.exit
Exit this program
.explain ON|OFF
Turn output mode suitable for EXPLAIN on or off.
.genfkey ?OPTIONS?
Options are:
--no-drop: Do not drop old fkey triggers.
--ignore-errors: Ignore tables with fkey errors
--exec: Execute generated SQL immediately
See file tool/genfkey.README in the source
distribution for further information.
.header(s) 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 on TABLE
.load FILE ?ENTRY?
Load an extension library
.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
Print STRING in place of NULL values
.output FILENAME
Send output to FILENAME
.output stdout
Send output to the screen
.prompt MAIN CONTINUE
Replace the standard prompts
.quit
Exit this program
.read FILENAME
Execute SQL in FILENAME
.rest
相关文档：
SQLite Tutorial in PHP
SQLite is an SQL database manager used locally or on a website, and compatible
in particularly with PHP.
Summary
Installing SQLite and creating a database
.
Installing SQLite. Verifying the installation by creating a base.
Creating and using a SQLite tabl ......
OS X自从10.4后把SQLite这套相当出名的数据库软件，放进了作业系统工具集里。OS X包装的是第三版的SQLite，又称SQLite3。这套软件有几个特色：
软件属于公共财（public domain），SQLite可说是某种「美德软件」（virtueware），作者本人放弃着作权，而给使用SQLite的人以下的「祝福」（blessing）：
May you do good an ......
SQLite学习笔记
1.查看有哪些数据库,显示数据库列表
show databases;
2.显示表的结构
方法一：
use student;
describe student;
方法二：
des student.student;
方法三：
show columns from student;
3.显示MYSQL的版本
select version();
4.显示库中的数据表
use mysql;
show tables;
5.建库
......
1、.back ?DB? FILE 备份DB(默认为main)到文件
2、.bail ON|OFF 遇到一个错误扣停止，该值默认为OFF
3、.databases 列举附加到数据库的数据库名和文件名
4、.dump ?TABLE? ... 用SQL文本格式列举数据库，如果指定TABLE，仅仅列举匹配的表，LIKE类型TABLE
5、.echo ON|OFF 设置echo的状态 ......
首先做点铺垫说明：
sqlite程序通过查找分号(;)来决定一个SQL语句的结束,所以要执行SQL语句请确保在SQL语句后有分号(;).如果你省略分号，sqlite3将给你一个连续的命令提示符(...> )并等你给当前的SQL命令添加更多的文字。这个特点让你输入多行的多个SQL语句.但点号(.)命令不要分号(;).ctrl+c可以结束当前命令。
在dos� ......
