番外：ubuntu 下的sqlite3

MoonlitHan

已于 2024-12-19 16:27:28 修改

阅读量1.3k

点赞数 29

分类专栏： Linux下socket 文章标签：数据库 linux

于 2024-12-14 22:35:05 首次发布

本文链接：https://blog.csdn.net/wh_xia_jun/article/details/144475696

版权

What Is SQLite?

SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world

ps:SQLite Home Page

sqlite3 的安装：

user@user-virtual-machine:~$ sqlite3

Command 'sqlite3' not found, but can be installed with:

sudo apt install sqlite3

user@user-virtual-machine:~$ sudo apt install sqlite3

还需要安装开发库呢：

sudo apt-get update
sudo apt-get install libsqlite3-dev

可视化工具：sudo apt-get install sqlitebrowser

命令行方式创建表：

$ sqlite3 ex1
SQLite version 3.36.0 2021-06-18 18:36:39
Enter ".help" for usage hints.
sqlite> create table tbl1(one text, two int);
sqlite> insert into tbl1 values('hello!',10);
sqlite> insert into tbl1 values('goodbye', 20);
sqlite>