Abnormal conditions:
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.
When using the secure update mode, the update statement must use a keyword column attribute to limit the scope of the update. If you do not use keyword columns to limit the scope or update all records, you cannot use safe update mode.
The solution is to execute the following statement to set it to non secure update mode.
#Non-secure mode
SET SQL_SAFE_UPDATES=0;
#secure mode
SET SQL_SAFE_UPDATES=1;
Read More:
- MySQL Workbench: Error Code: 1175 [How to Solve]
- [Solved] Mysql Close safe-updates Mode Error: Error Code: 1175
- [Solved] MySQL Execute update error: error code: 1175
- MYSQL Safe Upgraded Error: You are using safe update mode and you tried to update
- MYSQL 5.7 Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it..
- Bulk Update Error: #Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the m
- MYSQL gruop by Error: this is incompatible with sql_mode=only_full_group_by
- Introduction to Relational Databases in SQL
- How to Solve Mysql8 load data error
- [Solved] MySQL Error: “Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre”
- [Solved] MySQL Error: ERROR 1055 (42000)sql_mode=only_full_group_by
- How to quickly locate the problem in DB2-407 error reporting SQLCODE: -407, SQLSTATE: 23502
- How to Solve MYSQL into outfile Error13
- [Solved] MySQL: Syntax error or access violation: 1055 Expression #1 of SELECT list is not …
- [Solved]ERROR 1067 (42000): Invalid default value for ‘end_time‘ Mysql
- [Solved] Sequelize DatabaseError: ER_WRONG_FIELD_WITH_GROUP: Expression #2 of SELECT list is not in GROUP
- MySQL OrderBy Error: Expression #1 of ORDER BY
- [Solved] Mysql Error: [Err] 1136 – Column count doesn‘t match value count at row 1
- Solve ERROR 1136 (21S01) in Mysql: Column count doesn’t match value count at row 1
- [Modified] Hive SQL Error: SQL ERROR [10004] [42000]: Error while compiling statement: FAILED: SemanticException [Error