ubuntu21.10 sqlite安装和使用

sudo apt-get install sqlite sqlite3 -y

sudo apt-get install libsqlite3-dev 

创建数据库
sqlite3 student.db
查看表
.tables
创建表
create table student(name, num);
查看表结构
.schema student
查看数据
select * from stdudent;
插入数据
insert into student values("zhangsan", 10001);
insert into student (name) values("lisi");
删除表
drop table student 
删除某条数据
delete from student where name = "lisi";

修改
update student set name = "xx" where name = "lisi";
推出
.exit