更新刪除遇到Error Code: 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. 原來是mysql有個叫SQL_SAFE_UPDATES的變數， 為了資料庫更新操作的安全性，此值預設為ON 所以只要在執行下面的指令即可 SET SQL_SAFE_UPDATES=0;//關閉 //You want do something... UPDATE XXXXXX SET XXXXXX WHERE XXXXXXX; DELETE XXXXXX WHERE XXXXXXX; SET SQL_SAFE_UPDATES=1;//結束後再開啟 大家可以試試看