2013年1月31日 星期四

MySQL Workbench 5.2 CE


執行MySQL Workbench 5.2 CE update or 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 -> Query Editor and reconnect.
到工能表的Edit>Preferences>SQL Queries> General > 取消 "Safe Updates".Forbid UPDATEs and DELETEs whih no key in WHERE clause or no LIMIT clause. Requires a reconnection.
再重連接DB 就可以。

沒有留言: