在 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
該怎麼辦呢?
- 打開 mysql workbench
- Edit → Preferences
- workbench 6.0,選擇 SQL Queries 頁籤
- workbench 6.3,選擇 SQL Editor 頁籤
- 反勾選Safe Updates. Forbid UPDATEs And DELETEs with no key in WHERE clause or no LIMIT clause. Requires a reconnection
- workbench 重新連線
- 即可正常執行
沒有留言:
張貼留言