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
Original: https://blog.csdn.net/u010451643/article/details/121292030
Author: 哈四五六
Title: ubuntu21.10 sqlite安装和使用
原创文章受到原创版权保护。转载请注明出处：https://www.johngo689.com/816278/
转载文章受原作者版权保护。转载请注明原作者出处！