sudo apt-get install sqlite3
sudo apt-get install sqlitebrowser
sudo apt-get install sqliteman
//常用指令
.database
.tables
.schema
.dump table_name
.separator :
.mode column
.width 2
.show
.help
.quit
.exit
create table student_info(stu_no interger primary key, name text);
Insert into student_info(stu_no, name) values(0001, alex);
update student_info set stu_no=0001, name=hence where stu_no=0001;
delete from student_info where stu_no=0001;
select * from student_info;
ubuntu安装sqlite3可视化工具
最新推荐文章于 2024-06-04 16:12:56 发布