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:
- Bulk Update Error: #Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the m
- java.sql.SQLException: Disk full (/tmp/#sql_1eaa2_60.MAI); waiting for someone to free some space
- [Solved] java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corres
- [Linux Docker Mirror] MYSQL Run sql Script Error: Failed to open file ‘/home/mydatabase.sql‘, error: 2
- [Solved] SQL Error: Method queryTotal execution error of sql
- [Modified] Hive SQL Error: SQL ERROR [10004] [42000]: Error while compiling statement: FAILED: SemanticException [Error
- Introduction to Relational Databases in SQL
- MySQL 8.0.12 runs SQL error #1055 [How to Solve]
- How to Solve SQL state [HY000]: general error 2503
- Can mybatis prevent SQL injection
- SQL Server Deletes a table foreign key constraint Error [Solved]
- [Solved] Pyodbc.ProgrammingError: No results. Previous SQL was not a query.
- SQL statement to calculate the distance between two coordinates
- [Solved] pymysql.err.ProgrammingError: (1064, ‘You have an error in your SQL syntax;
- MYSQL gruop by Error: this is incompatible with sql_mode=only_full_group_by
- [Solved] MySQL Error: ERROR 1055 (42000)sql_mode=only_full_group_by
- Error 1418 (HY000): this function has none of deterministic, no SQL
- [Solved] MYSQL 5.7 gruop by eRROR: this is incompatible with sql_mode=only_full_group_by
- Navicat connecting to SQL Server Error [How to Solve]
- [SQL ERROR] SQL Error: could not execute statement & query did not return a unique result: 2; nested excepti