1、創(chuàng)建庫
??#sqlite3 name.db
2、創(chuàng)建表
??>create table tabelname (field1[類型] ,field2[類型] ,field3[類型].....);
3、修改表
??>alter table tablename add culumn fieldN;? ?只適用與追加
4、刪除表
??>drop table tablename;
5、列出表格
??> tables or show tables;
6、顯示庫結(jié)構(gòu)
??> schema tablename;
7、數(shù)據(jù)操作
? ?查詢 select??from tablename;
? ?增加 insert into tablename values(filed|value);
? ?刪除 delete from tablename ;
? ?改變 update tablename set filedN=valueN;
以上數(shù)據(jù)操作均可以跟where條件表達(dá)式，orderby
邏輯表達(dá)式有??AND OR NOT > =??= + = * / ()
.還有很有用的SQL
Select * from Sqlite_master
Select datetime('now')
Select date('now')
Select time('now')
數(shù)據(jù)類型和創(chuàng)建表示例
CREATE TABLE ex2
(
a VARCHAR(10),
b NVARCHAR(15),
c TEXT,
d INTEGER,
e FLOAT,
f BOOLEAN,
g CLOB,
h BLOB,
i TIMESTAMP,
j NUMERIC(10,5)
k VARYING CHARACTER (24),
l NATIONAL VARYING CHARACTER(16)
);