Error Code: 1175. You are using safe update mode

So today’s annoyance and resulting note to myself is Error Code 1175 – and safe mode for updates.

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 and reconnect.

I am trying to make a LOT of changes to a common field across an entire table… for what it’s worth 12,559 rows in this case.

It just is not happening.

So heading over the the DB backend server (MariaDB 10.2) and as the admin user make with:

MariaDB [(none)]> SET SQL_SAFE_UPDATES = 0;
Query OK, 0 rows affected (0.00 sec)

Run it again – and happy days all is good.

Then – because it would have stopped me doing dumb things by accident in the first place.

MariaDB [(none)]> SET SQL_SAFE_UPDATES = 1;
Query OK, 0 rows affected (0.00 sec)

Thank you and goodnight.

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this:
Skip to toolbar