When performing a batch database update using MySQL Workbench, executing a statement will encounter the following error:
Error Code: 1175 You are using safe… without a WHERE that uses a KEY column
Because MySQL Workbench’s default security Settings do not allow batch table updates. This error is prompted when the SQL statement to be executed is batch update or delete.
The solution is as follows:
Open the Workbench menu [Edit]-> [Preferences…] -> Switch to the [SQL Queries] page -> Remove the [Safe Updates] check -> Click the [OK] button
Finally, just restart the SQL Editor and make a new connection.
Or before I make a query,
Execute the following statement:
Error Code: 1175 You are using safe… without a WHERE that uses a KEY column
Because MySQL Workbench’s default security Settings do not allow batch table updates. This error is prompted when the SQL statement to be executed is batch update or delete.
The solution is as follows:
Open the Workbench menu [Edit]-> [Preferences…] -> Switch to the [SQL Queries] page -> Remove the [Safe Updates] check -> Click the [OK] button
Finally, just restart the SQL Editor and make a new connection.
Or before I make a query,
Execute the following statement:
SET SQL_SAFE_UPDATES = 0;
Read More:
- MySQL Workbench: Error Code: 2013. Lost connection to MySQL server during query solution
- mysql workbench Error Code: 1046. No database selected Select the default DB to be used
- Solution to MySQL workbench error 1148 unable to load local data
- MySQL Workbench Failed to Connect to MySQL at 127.0.0.1:3306 with user root Bad handshake
- [How to Fix] MySQL Workbench for Mac Flashback
- How to Solve MacOS Big Sur MySQL workbench flashback problem
- MySQL workbench insert data prompt error: 1046 (errorcode: 1046. No database select…)
- After installing MySQL again under Linux, the solution of ‘MySQL module failed to start’ appears
- MySQL local connection Error 1130_ The solution of MySQL 1130 error report when remote connection through Navicat for MySQL
- Golang MySQL error SQL: unknown driver “MySQL” (Forgotten import?) solution
- Workbench Could not connect the SSH Tunnel Authentication error
- MySQL error code ‘1064’ troubleshooting process
- Solve geforce error code with super full solution CODE:0x0003 Problem approach
- Summary of MySQL error code
- Solution to MySQL Error 1130 problem
- Error Code: 2006 – MySQL server has gone away
- MySql ERROR CODE:1215 Cannot add the foreign key constraint
- Geforce experience appears something went wrong error code 0x0003 error code solution
- Call to undefined function mysql_ Connect() solution summary
- Solution of MySQL data garbled problem