## 安裝`mysqlchain`
本擴展包可以通過`pip`或`pip3`來安裝
```
pip install mysqlchain
```
## 導入擴展包并初始化模塊
~~~
from mysqlchain import chain
config = {
'host': 'localhost',
'port': 3306,
'user': 'root',
'password': '123456',
'database': 'testdata',
'charset': 'utf8'
}
db = chain(config)
~~~
>[danger] 實例化模塊，并傳入`config`字典參數，其中`user、password、database`為必傳項，否則無法連接數據庫
- 連接數據庫
- 鏈式操作方法
- distinct
- field
- withoutField
- name
- alias
- force
- join
- leftJoin
- rightJoin
- union
- unionAll
- where
- whereOr
- whereTime
- whereBetweenTime
- whereNotBetweenTime
- whereBetweenTimeField
- whereNotBetweenTimeField
- whereYear
- whereMonth
- whereWeek
- whereDay
- group
- having
- order
- orderRand
- limit
- page
- lock
- comment
- ignore
- inc
- dec
- fetchSql
- 查詢數據
- 聚合查詢
- 新增數據
- 更新數據
- 刪除數據
- 原生操作