SQLite 是一种小型化易部署的数据库，其大部分语法都能和 MySQL 通用
2. Table
Check information of all the columns in a table
PRAGMA table_info(tb)
For example, for a table called ‘Pets’ |PetId|PetName|TypeId| |-|-|-|-| |1|Bob|1| |2|Sam|1| |3|Tom|2|
PRAGMA table_info(Pets)
>>>
cid name type notnull dflt_value pk
---------- ---------- ---------- ---------- ---------- ----------
0 PetId INTEGER 0 1
1 PetName 0 0
2 TypeId 0 0
5. Function
5.5 String
(1) Length
length(str)
10. C.R.U.D Methods
- Create - INSERT
- Read - SELECT
- Update - UPDATE
- Delete - DELETE
Document Information
- Author: Zeka Lee
- Link: https://zhekaili.github.io/0009/03/01/SQLite-Doc/
- Copyright: 自由转载-非商用-非衍生-保持署名（创意共享3.0许可证）