1175 에러 발생~
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 > Preferences > SQL Editor > Other에 있는 safe updates 체크 풀기! > 재시작
💥💥💥💥💥체크풀기!!
💥💥💥💥💥재시작필수!!!!
'개발공부 > DB' 카테고리의 다른 글
| [Mysql workbench] 에러 1265 : Data truncated for column (0) | 2020.11.18 |
|---|---|
| [Mysql workbench] 에러 1064 : You have an error in your SQL syntax; (2) | 2020.11.18 |
| [Mysql workbench] csv파일 import 오류 : Can't analyze file. Please try to change encoding type. (0) | 2020.11.12 |
| [MYSQL] 컬럼 COMMENT 조회방법 (0) | 2020.10.23 |
| WHERE 1 = 1 을 쓰는 이유 (1) | 2019.10.08 |
