Error (Error Code: 1175) during executing update command on table using MySQL Workbench 5.2

Question

I'm using MySQL Server5.5 in which MySQL Workbench 5.2 CE is included. I'm using MySQL Workbench 5.2 . I have a table named user in DB. I executed the following command on SQL Editor at MySQL Workbench:

UPDATE user SET email = '[email protected]' WHERE email='[email protected]';

But unfortunately I got the following error:

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.

What's the wrong? Help is highly appreciated.

user is a reserved word, you probably also need to enclose it with backticks. — user330315
– user330315, Commented Jan 9, 2013 at 8:49
@a_horse_with_no_name: good suggestion though I did not face any problem in my case — Ripon Al Wasim
– Ripon Al Wasim, Commented Jan 9, 2013 at 9:06

Vishrant · Accepted Answer · 2016-12-17 13:57:02Z

36

Every time you encountered that kind of error when trying to update rows in mysql, It’s because you tried to update a table without a WHERE that uses a KEY column.

You can fix it using,

SET SQL_SAFE_UPDATES=0;
UPDATE user SET email = '[email protected]' WHERE email='[email protected]';

or in the WorkBench

Edit -> Preferences -> SQL Queries
Uncheck Forbid UPDATE and DELETE statements without a WHERE clause (safe updates)
Query --> Reconnect to Server

edited Dec 17, 2016 at 13:57

Vishrant

16.9k12 gold badges87 silver badges139 bronze badges

answered Jan 9, 2013 at 8:48

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

John Woo Over a year ago

@a_horse_with_no_name but email column has no key defined.

Ripon Al Wasim Over a year ago

SQL_SAFE_UPDATES is a system variable, right? How can I get the list of system variable in MySQL Workbench?

KNU Over a year ago

in workbench 6.2 I didn't find "SQL Queries" instead found "SQL Editor"

Cristian · Accepted Answer · 2018-10-25 07:40:01Z

3

It is more correct to deactivate and reactivate

SET SQL_SAFE_UPDATES=0; --disable
UPDATE user SET email = '[email protected]' WHERE email='[email protected]';
SET SQL_SAFE_UPDATES=1; --enable

edited Oct 25, 2018 at 7:40

answered Oct 25, 2018 at 7:28

Cristian

538 bronze badges

Collectives™ on Stack Overflow

Error (Error Code: 1175) during executing update command on table using MySQL Workbench 5.2

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related