sqlite3 增删改查:

## 进入 sqlite3
sqlite3 /home/kaye/student

## 进入 sqlite3 并保存数据库到指定路径
sqlite3

## 退出 sqlite3
.exit

## 创建表
create table student (id integer, name text, age integer);

## 查看表结构
.schema

## 插入数据
insert into student (id, name, age) values (1, "bb", 11);
insert into student values (2, "cc", 33);

## 查询数据
select * from student;

## 修改数据
update student set age=25 where id=3;

## 删除数据
delete from student where id=1;

## 删除表
drop table student;