- create table people (id integer,name text,age integer,class text); //创建
- insert into people (id,name,age,class) values (2,'Maggie',18,'1602'); //增加
- delete from people where name='Maggie'; //删除
- update people set age=17 where name='Maggie'; //修改
- select * from people where age<18 or class='1602'; //查找
- select *from people where name like = 'xiao%';
sqlite增删改查语句
最新推荐文章于 2024-03-18 09:40:09 发布