//数据库的基本操作:增删改查(CRUD: create retrieve update delete)
//创建表
create table info(_id integer primary key,name varchar(20),age varchar(20))
//增
insert into info(name,age) values('zs',18)
//删
delete from info (全部删除)
delete from info where age = 18(删除年纪18的数据)
//改
update info set name = 'ls' where age >15 and age < 18(修改年纪在15到18之间的名字为ls)
//查
select * from info where age > 16 order by age desc limit 2(查询年纪在16岁以上,按年纪降序排列,限制数量为2)
SQL基本增删改查语句
最新推荐文章于 2024-06-22 22:33:28 发布