1. SQLite數(shù)據(jù)庫數(shù)據(jù)類型
- integer
- varchar(10)
- float
- double
- char(10)
- text
2. sql回顧
2.1 創(chuàng)建表的語句
create table 表名(字段類型 數(shù)據(jù)類型 約束, 字段名稱 數(shù)據(jù)類型 約束……)
create table person (_id integer primary key, name varchar(10), age integer not null);
2.2 刪除表語句
drop table 表名
drop table person;
2.3 插入數(shù)據(jù)
insert into 表名[字段, 字段.....] values(值1,值2......)
insert into person(_id,age) values(1,20);
insert into person values(2,'uncle firefly',24);
2.4 修改數(shù)據(jù)
update 表名 set 字段=新值 where 修改條件
update persion set name='螢火蟲叔叔',age=25,where _id=2;
2.5 刪除數(shù)據(jù)
delete from 表名 where 刪除條件
delete from person where _id=1;
2.6 查詢語句
select 字段名 from 表名 where 查詢條件 group by 分組字段 having 篩選條件 order by 排序字段
select * from person;
select _id,name from person;
select * from person where _id=1;
select * from person where _id<>1;
select * from person where _id=1 and age>18;
select * from person where name like "%fire%";
select * from person where name like "螢火%";
select * from person where name is null;
select * from person where age between 10 and 20;
select * from person where age>18 order by _id;
