查詢資料
1055 - Expression #1 of ORDER BY is not in GROUP BY clause and contains nonaggregated column '' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by，
修改資料
[Err] 9500 - transaction too large, size:104857974
uj5u.com熱心網友回復：
啥意思？沒看懂。。。亂入，為你祝福
uj5u.com熱心網友回復：
tidb.toml添加:sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
uj5u.com熱心網友回復：
tidb.toml添加:sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
我加在tidb.toml第一行。還是報this is incompatible with sql_mode=only_full_group_by
sql_mode組態檔加在什么地方
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/49942.html
標籤：非技術區
下一篇：資料庫