Android原生SQLite常用SQL语句

Android原生SQLite常用SQL语句

创建表

CREATE TABLE student (id integer primary key autoincrement, name varchar(30), age integer)

增

INSERT INTO student(name, age) VALUES("张三", 20)

删

DELETE FROM student WHERE name=张三

改

UPDATE student SET age=20 WHERE name=张三

查

SELECT name FROM student WHERE age=20

增加字段

ALTER TABLE student ADD COLUMN sex varchar(30)

删除字段

ALTER TABLE student DROP COLUMN sex