DB/MySQL
![[MySQL] Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.](https://img1.daumcdn.net/thumb/R750x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2FbuZAp8%2FbtszkBzWsFx%2F8u6kwop4260QZlS367kciK%2Fimg.png)
[MySQL] Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
Edit>preference>SQL Editor에 Safe Updates를 체크 해제하고, MySQL Workbench를 재시작합니다.
![[MySQL] 재설치 후 오류모음](https://img1.daumcdn.net/thumb/R750x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2FbPfReM%2FbtsjdmjaGcU%2F7u3hIKSkIpyUZVBakrOMu0%2Fimg.png)
[MySQL] 재설치 후 오류모음
# which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'schema_name.table_name.column_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by0.000 s..