How To Fix MySQL WorkBench Error Code 1175 | DISABLE Safe Update Mode Restriction

Показать описание

This is How to fix Error Code 1175 in MySQL Workbench. This error happen because you are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.

In short If the checkbox is enabled for Safe Updates it rejects UPDATEs and DELETEs with no Restrictions.

Specifically the Safe Mode option ENABLES the SQL_SAFE_UPDATES option for the session. If enabled, MySQL aborts UPDATE or DELETE statements
That do not use a key in the WHERE clause or a LIMIT clause. This makes it possible to catch UPDATE or DELETE statements where keys are not use properly and that would probably change or delete a large number of rows. Changing this option requires a reconnection.

Subscribe for more content like this:

About the Content:

"MySQL WorkBench - Disable Safe mode / Safe UPDATE or DELETE in mySQL | Solution for Error Code 1175 | Tookootek | How To #002" is quick fix so it only have 1 part.

Chapters:
00:00 Introduction
00:03 How To Disable Safe Update Mode Walkthrough
01:20 Outro

Playlist