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
複製程式碼