DB/MYSQL
[ MYSQL ] WHERE 를 통한 DELETE 안될때
HEON.D
2021. 9. 25. 12:03
에러메세지
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.
해결방법
Safe 모드 비활성화
set sql_safe_updates=0;
작업후 다시 Safe 모드를 활성화 시켜놓을 것
set sql_safe_updates=1;