1.SELECT
a.选择所有数据
b.选择某列
c.选择多列
d.选择某行某列
其他WHERE语句
WHERE age between 32 and 38
WHERE gender='Male'
e. 排序
默认增序：order by age
降序排列：order by desc
2.DELETE语句
DELETE FROM employee WHERE name = 'mark'
3.INSERT语句
INSERT INTO employee(EmployeeID,Name,Surname,Age,Gender) VALUES(3,'Tao','Jiang',36,'Male')
4.UPDATE语句
UPDATE employee set name = 'seaman' WHERE EmployeeID = 3
5. CREATE语句
原文链接：https://www.f2er.com/sqlite/199160.html
