情境:
使用MySQL Workbench執行SQL出現以下問題:
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 -> Query Editor and reconnect.
解決方法
最前面加入以下指令
SQL_SAFE_UPDATES = 0