mysql資料庫-警告問題

標籤：mysql

在mysql用戶端執行delete刪除語句時，報出了以下錯誤：
問題：
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and
contains nonaggregated column ‘information_schema.PROFILING.SEQ‘
which is not functionally dependent on columns in GROUP BY clause;
this is incompatible with sql_mode=only_full_group_by
解決方案:

使用vi命令編輯該檔案，增加以下語句：
sql_mode=‘STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION‘
儲存後， 重啟mysql服務
解決完畢！

mysql資料庫-警告問題