sqlite学习笔记 | SparkydogX Blog

[sparkydogX]

https://sparkydogx.github.io/2019/08/15/sqlite-notes/#more

本文以Ubuntu中的sqlite为例 安装sqlitesudo apt-get install sqlite 创建数据库sqlite3 testDB.db 创建表1234567sqlite> CREATE TABLE COMPANY( ID INT PRIMARY KEY NOT NULL, NAME TEXT NOT NULL, AGE