Permenantly disable Safe Updates in MySQL Workbench?

8
votes

Re: the error "You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column"

The two options to fix this are disabling safe mode through the gui (Edit>Preferences>Sql Editor) or by manually entering SET SQL_SAFE_UPDATES = 0;

However, everything I'm reading seems to indicate you must do this every time you connect. Is there a way to disable Safe Update Mode permanently so I don't need to do this every time?

1
mysqlmysql-workbench
The setting in the preferences is permanent. - Shadow
Maybe this isn't the "fix" you actually need to the problem you actually have. - philipxy
It would be easy to test that. Run an unsafe query to see if that gives you the error. Then set the option in the preferences to ignore unsafe queries, close Workbench, reopen it and run the query again. You will then see there's no error from Workbench. - Mike Lischke
There is no way to turn it off in Mac OS Workbench 6.3. The option does NOT exist. - Steve Gon
The setting in the preferences is NOT permanent, at least not in Windows-world - DJDave

1 Answers

1
votes

Given that Workbench (at least in Windows-world) restores your open queries, if you keep SET SQL_SAFE_UPDATES = 0; in a query window, it will be quicker to re-run at start-up than re-entering it. Maybe there are other settings which aren't saved but could be added too. Like if there was one to say "no side panels please", or "show Schema, not Administration".

Not ideal, but every little helps.