sqlite命令行工具简单操作

在Win32下面操作，先看下sqlite.exe的帮助：

D:\>sqlite3.exe -help

Usage: sqlite3.exe [OPTIONS] FILENAME [SQL]

FILENAME is the name of an SQLite database. A new database is created

if the file does not previously exist.

OPTIONS include:

   -help                show this message

   -init filename       read/process named file

   -echo                print commands before execution

   -[no]header          turn headers on or off

   -bail                stop after hitting an error

   -interactive         force interactive I/O

   -batch               force batch I/O

   -column              set output mode to 'column'

   -csv                 set output mode to 'csv'

   -html                set output mode to HTML

   -line                set output mode to 'line'

   -list                set output mode to 'list'

   -separator 'x'       set output field separator (|)

   -stats               print memory stats before each finalize

   -nullvalue 'text'    set text string for NULL values

   -version             show SQLite version

   -vfs NAME            use NAME as the default VFS

１、创建DB文件（存在的话则打开）

D:\>sqlite3.exe test.db

SQLite version 3.7.9 2011-11-01 00:52:41

Enter ".help" for instructions

Enter SQL statements terminated with a ";"

sqlite>

说明：使用“.help”可以查看帮助，SQL语句使用分号";"结束。

２、创建表

sqlite> CREATE TABLE user(id int, name varchar(20));

３、查看创建表的SQL语句

sqlite> .schema user

CREATE TABLE user(id int, name varchar(20));

４、插入

sqlite> INSERT INTO user ('id', 'name') values(1, 'LiLei');

sqlite> INSERT INTO user ('id', 'name') values(2, 'HanMeimei');

５、查询

sqlite> SELECT * from user;

1|LiLei

2|HanMeimei

６、删除

sqlite> DELETE FROM user WHERE id=2;

７、更新

sqlite> UPDATE user SET name='Xiaoming' WHERE id=1;

８、删除表

sqlite> DROP TABLE user;

９、帮助

sqlite> .help

.backup ?DB? FILE      Backup DB (default "main") to FILE