thinkphp6.0數據庫上 · 常用筆記

# thinkphp6.0數據庫上 Db::getLastSql(): 可以得最近一條原生的sql語句： ****處理數據庫部分：**** 1 **分批查詢** ![](https://img.kancloud.cn/c6/36/c6362b6f1fb4bff97701acde9b7d6629_1196x386.png) 2 **游標查詢** ![](https://img.kancloud.cn/bf/88/bf8885e973a38afa9fd143a03b7f964a_826x187.png) 3 **采用實例的方法減少內存** ![](https://img.kancloud.cn/53/4e/534e4f91ef844db0d17e830a13601099_686x388.png) 4 **添加沒有的字段避免報錯強制新增** ![](https://img.kancloud.cn/09/68/09683cf6e0cb9cee44ca13a834b1a682_850x436.png) 5 **批量增加數據** ![](https://img.kancloud.cn/12/8b/128b7e49be91e20879a7fef96a1c9de5_725x478.png) 6 **通用新增和修改自動判斷** ![](https://img.kancloud.cn/71/35/713509e70e80774a6b8b40641f23f4a6_818x229.png) ![](https://img.kancloud.cn/32/9c/329cde573b807d72c9af9a3282d276e6_1163x208.png) 7：**使用數據庫函數進行數據修改** ![](https://img.kancloud.cn/4b/f9/4bf9d752afe31e38174ffadeaf872ccd_728x295.png) ![](https://img.kancloud.cn/4b/da/4bda1249c1939e5c21fe893a9ab8b2b8_845x337.png) 8 **數據庫刪除數據** ![](https://img.kancloud.cn/98/bc/98bc5e69ae77f9c1517e64ad377d7a05_817x370.png) 9 **數據庫區間查詢** ![](https://img.kancloud.cn/f7/7c/f77c5fcdefc89664f85eea3f50cebc89_856x504.png) 10 **取出固定id的值** ![](https://img.kancloud.cn/70/68/70686dca44c66f0e918cb830d11ccac9_869x304.png) ![](https://img.kancloud.cn/03/0b/030b2409bb1cdc07f56e3f1a668f2ebc_705x351.png) 11 **自己拼接sql語句** ![](https://img.kancloud.cn/fa/5e/fa5e69fcd9933afc9f48722dd3db6b09_790x210.png) 12 **時間查詢** ![](https://img.kancloud.cn/a7/a9/a7a9969cd1dac20e08e693986a94c84f_824x431.png)![](https://img.kancloud.cn/95/94/95940953efdecb6d619feb0574605bd7_707x191.png) ![](https://img.kancloud.cn/77/b7/77b7ea052cba34c4af4dc9a6ab9692e4_705x282.png)![](https://img.kancloud.cn/27/2b/272b1a174af1ebaaea961624ad5d8878_802x260.png) ****二：子查詢**** ![](https://img.kancloud.cn/79/bb/79bb66f7db6aa018cd3d5ad5b3041f95_980x253.png) ![](https://img.kancloud.cn/80/e9/80e93ed4af02583d54c47c5a52d8be1c_770x73.png) 1. ****閉包查詢**** ![](https://img.kancloud.cn/38/ec/38ecb888cf8584b0a17ddfdf8cf3f11c_699x113.png) 2. ****原生查詢**** ![](https://img.kancloud.cn/16/b4/16b46b6b43268319bacceb788b522dcb_791x211.png) **where和whereOR** ![](https://img.kancloud.cn/b1/ad/b1ad88240506435089440a134364a509_1031x145.png) **生成的sql語句** ![](https://img.kancloud.cn/f6/28/f628ee1687b20f97790ed70bb3dd9211_1132x47.png) **group 對多字段組合** ![](https://img.kancloud.cn/4c/40/4c40a9fdac4775f3b03a4c5aa9b8da92_768x259.png)![](https://img.kancloud.cn/09/e0/09e02a31686706ca1acf2e42dc169adc_622x238.png) **特殊條件查詢用Db::raw 不然條件不成立比如>=:** ![](https://img.kancloud.cn/25/f7/25f7cb2594cd06a629550cf25fae81c2_472x158.png) **數據庫閉包查詢：** ![](https://img.kancloud.cn/cc/0c/cc0cb11c6d28c477efbfec581ab4f0f0_778x318.png) ****數據庫兩個字段比較**** ![](https://img.kancloud.cn/68/f0/68f0e9cb63c178db544c93e0eb3e9f58_729x207.png) **數據庫針對字段快捷查詢** ![](https://img.kancloud.cn/67/d2/67d262189f32c3037a5600fb489fe569_741x240.png) **分支查詢：** ![](https://img.kancloud.cn/7d/04/7d045ade928b207dc91aa14799884e90_624x200.png)