简单的SQL语句记一下,免得自己忘记

Android SQLite 适用

创建表

①create table if not exists table_name (_id Integer primary key autoincrement,column_1 Integer,column_2 String,column_3 blob);

删除表

②drop table if exists table_name;

增

③insert into table_name(column_1,column_2,column_3,column_4)values(value_1,value_2,value_3,value_4)

删

④delete from table_name where column_1=value_1;

or delete from table_name where _1>10;

改

⑤update table_name set column_2=value_100 where column=value_1 and column_3=value_3;

查

⑥select * from table_name 

select * from table_name where _id<20 order by _id desc limit 12;