(1)insert into 表明(字段,字段...) values(值1,值2...)
例如:insert into person(_id,age) values(1,20)
注:上面语句中values后面的值要和前面的字段一一对应
(2)insert into 表明 values(值1,值2...)
例如:insert into person values(1,"zs",20)
注:values后面的值要和创建表时的字段顺序一一对应
5.修改数据
update 表明 set 字段=新值 where 修改的条件
例如:update person set name="ls",age=30 where _id=1
6.删除数据
delete from 表明 where 删除的条件
例如:delete from person where _id=2
7.查询数据
select 字段名 from 表明 where 查询条件 group by 分组的字段 having 筛选条件 order by 排序字段
例如:
(1)select * from person
(2)select _id,name from person
(3)select * from person where _id=1
(4)select * from person where _id<>1
(5)select * from person where _id=1 and age>18
(6)select * from person where name like "%小%"("%小%"表示“小”字前后可以含有任意多字符)
(7)select * from person where name like "_小%"(表示一个字符后面跟一个“小”字,然后“小”字后面再跟任意多字符)
(8)select * from person where name is null
(9)select * from person where age between 10 and 20
(10)select * from person where age>18 order by _id