## 原生操作
>[info]查詢數據
~~~
db.query('select * from user')
~~~
>[info]新增數據
~~~
db.execute("insert into user (name, age) values ('admin', 25)")
~~~
>[info]更新數據
~~~
db.execute('update user set status = 1 where id = 1')
~~~
>[info]刪除數據
~~~
db.execute('delete from user where id = 1')
~~~
>[info]清空數據表
~~~
db.query('truncate table user')
~~~
>[danger]以上操作成功返回1,失敗返回0,如果操作失敗,數據庫會自動回滾
- 連接數據庫
- 鏈式操作方法
- 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
- 查詢數據
- 聚合查詢
- 新增數據
- 更新數據
- 刪除數據
- 原生操作