Skip navigation links

MySQL Forums :: MySQL Workbench :: safe update mode

Advanced Search

safe update mode
Posted by: Keith Bernard ()
Date: August 11, 2010 10:17AM


I am fine with MS SqlServer but fairly new to mysql

When trying to do a simple update
(e.g. update `myTestTable` set f1=499 where f1='449';)

with the latest MySQL Workbench 5.2.26 CE version 6432 I get this error message:

Error Code: 1175
You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column

I don't believe I got this with the previous version 5.2.25.

If I use phpMyAdmin it simply works...

In my normal htdocs/mysql/bin/my.ini file (I use Xampp so my docroot is htdocs) I have the following lines which appear to stop this mode:

# Remove the next comment character if you are not familiar with SQL

Is there somewhere else that I need to change just for MySQL Workbench to work the same ? I am sure it should be something fairly simple!


Options: ReplyQuote

Subject Views Written By Posted
safe update mode 28844 Keith Bernard 08/11/2010 10:17AM
Re: safe update mode 9870 Darrell DeVeaux 08/11/2010 11:21AM
Re: safe update mode 6549 Rewind Bussiness 09/14/2010 07:23PM
Re: safe update mode 6850 Mike Lischke 08/12/2010 01:40AM
Re: safe update mode 5707 Keith Bernard 08/12/2010 07:16AM
Re: safe update mode 4809 Miftah Thoha 08/18/2010 07:37AM
Re: safe update mode 4854 Keith Bernard 08/23/2010 06:39AM
Re: safe update mode 2235 Miftah Thoha 08/24/2010 10:52AM
Re: safe update mode 1669 warren charlot 09/13/2010 09:51PM
Re: safe update mode 1741 Fayiz MV 09/14/2010 06:25AM
Re: safe update mode 2642 Thomas Mobley 09/23/2010 10:00AM
Re: safe update mode 1731 Aren Cambre 09/13/2010 05:13PM
Re: safe update mode 1869 Brent William Peterson 08/30/2010 02:46PM
Re: safe update mode 2080 Ron Wheeler 11/05/2010 03:35PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.