SQLite语句
标签：
SQLite语句
建表
--create table if not exists student(id integer not null primary key,name text,age integer)
--插入
--insert into student (id,name,age)values(null,‘刘山‘,28)
--删表
--drop table student
--删除
--delete from student where id=4
--修改
--update student set name = ‘王五‘ where id = 3
--显示所有
--select *from student
--查找
--select *from student where id=3
--显示数据记录
--select count (*)from student
--降序显示
--select *from student order by age desc
--升序显示
--select *from student order by age asc
--列总和
--select sum (age) from student