常用SQLite语句

常用的SQL（structured query language 结构化的查询语言）语句

1，创建表
CREATE 创建
TABLE 表
PRIMARY KEY主键,唯一标示符；
AUTOINCREMENT自动增长
NOT NULL 非空
UNIQUE 唯一的

CREATE TABLE Teacher1 (teacher_id INTEGER PRIMARY KEY AUTOINCREAMENT NOT NULL UNIQUE, teacher_name TEXT,teacher_sex BOOLEAN)

CREATE TABLE Teacher2 (teacher_id INTEGER PRIMARY KEY AUTOINCREAMENT, teacher_name TEXT,teacher_sex BOOLEAN)

2, 删除表
DROP 丢弃 扔到

DROP TABLE Teacher1

3,给表添加列
ALTER 改变 修改

ALTER TABLE Teacher2 ADD teacher_age INTEGER

4,插入数据

INSERT INTO Teacher VALUES(1,‘zhangsan‘,1)
INSERT INTO Students (name,sex)VALUES(‘zhangsan‘,0)

5,查询数据
SELECT 查询
* 全部
FROM

SELECT * FROM Students

SELECT * FROM Students WHERE number<10
SELECT * FROM Students WHERE number<10 OR sex=1
SELECT * FROM Students WHERE number<10 AND number>5

like 匹配
SELECT * FROM Students WHERE name like ‘zhang%‘
SELECT * FROM Students WHERE name like ‘zhang_‘

LIMIT 限制
从第六条开始 往后的15条
SELECT * FROM Students LIMIT 5,15

6,修改数据
UPDATE 更新
set 设置

UPDATE Students set name=‘lisi‘,sex=1 where number < 10 AND number>5


7,删除数据
DELETE 删除

DELETE FROM Students WHERE number > 25

常用SQLite语句

原文：http://www.cnblogs.com/LkBolg/p/4964026.html