[MYSQL] 奇怪!怎麼下delete卻無法刪除資料，還跑出錯誤訊息!!!

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.

原來是MYSQL對於執行delete 沒有下 where 條件做的限制，理由應該是怕資料庫管理人員不慎將資料全部砍光光!XDDDD!!

因此必須加上SET SQL_SAFE_UPDATES=0;的語法，等delete執行完之後，在把SET SQL_SAFE_UPDATES=1;參數設定還原即可。

SET SQL_SAFE_UPDATES=0;
DELETE FROM INV_Invoice_IssueR_My;
SET SQL_SAFE_UPDATES=1;

select * from INV_Invoice_IssueR_My;
TRUNCATE TABLE INV_Invoice_IssueR_My;