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 = 'abc@yahoo.com' WHERE email='ripon.wasim@yahoo.com';

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.

possible duplicate of [MySQL error code: 1175 when updating](http://stackoverflow.com/questions/11448068/mysql-error-code-1175-when-updating) — fthiella, Jan 09 '13 at 08:47
`user` is a reserved word, you probably also need to enclose it with backticks. — a_horse_with_no_name, Jan 09 '13 at 08:49
@a_horse_with_no_name: good suggestion though I did not face any problem in my case — Ripon Al Wasim, Jan 09 '13 at 09:06

score 36 · Accepted Answer · edited Dec 17 '16 at 13:57

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 = 'abc@yahoo.com' WHERE email='ripon.wasim@yahoo.com';

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 '16 at 13:57

Vishrant

13,085
11
60
95

answered Jan 09 '13 at 08:48

John Woo

249,283
65
481
481

@a_horse_with_no_name but `email` column has no key defined. – John Woo Jan 09 '13 at 08:50
1

SQL_SAFE_UPDATES is a system variable, right? How can I get the list of system variable in MySQL Workbench? – Ripon Al Wasim Jan 09 '13 at 09:13
2

in workbench 6.2 I didn't find "SQL Queries" instead found "SQL Editor" – KNU Nov 22 '14 at 17:23

Cristian · Answer 2 · 2018-10-25T07:40:01.127

3

It is more correct to deactivate and reactivate

SET SQL_SAFE_UPDATES=0; --disable
UPDATE user SET email = 'abc@yahoo.com' WHERE email='ripon.wasim@yahoo.com';
SET SQL_SAFE_UPDATES=1; --enable

edited Oct 25 '18 at 07:40

answered Oct 25 '18 at 07:28

Cristian

43
8

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

2 Answers2

Linked