[mysql] Error Code: 1175. You are using safe update mode

[mysql] Error Code: 1175. You are using safe update mode

mysql 에서 테이블을 삭제하려고 할 때(delete from 테이블명) 아래처럼 에러 발생.

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. 0.000 sec

SQL 에디터에서

SET SQL_SAFE_UPDATES=0; 을 쿼리 실행하면 된다.