sqlite3 数据库

1.创建表 

create table if  not  exist student (id interger, name  text, tel  text);

2.查看表

.table

3.查看表结构

.schema student

4.修改表

alter table  student rename to  stu;  (修改表名)

alter  table student add column sex  text ；(修改某一属性)

5.插入数据

insert into  stuent (id, name, tel, sex)  value(1, "aa", "111", "m")

6.查询数据

select  * from stuent

select  name from  student  ;

select  * from stuent where id > 2

select name from stuent where  id < 2 or id > 3

select * from stuent where id between 2 and 4

7.修改数据

updata  stuent set  tel ="222" ;  where id = 2;

8.删除数据

delete  from stuent where id = 4

delete table stuent