Update my_table
Set name = 'abc';
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 Queries and reconnect.
MySQL 1175 error occurs when you are using Update query in safe mode, there are two solutions to fix this:
- Turn off Safe Mode by executing the query: SET SQL_SAFE_UPDATES=0; on you MySQL Workbeanch.
- Use the update query with WHERE clause.
To turn on Safe Mode again: SET SQL_SAFE_UPDATES=1;
More Posts related to MySQL,
- MySQL 1005 Error : SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Message: Can't create table '%s' (errno: 150)
- MySQL Error :1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB) Message: Can't create database 'mydb' (errno: 28)
- MySQL : Error :1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE) Can't create file
- MySQL ERROR 1064 (42000): You have an error in your SQL syntax [fix]
- MySQL #6 - Error on delete of './my-database/db.opt' (Errcode: 13 - Permission denied)
- Connection Failed: 1130 PHP MySQL Error
- MySQL Error :1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists
- How to clear mysql console screen
- MySQL: Error Code: 1175 You are using safe update mode
- MySQL : Error :1000 SQLSTATE: HY000 (ER_HASHCHK) Message: hashchk Server Error
- How to find AUTO_INCREMENT Fields value in MySQL table
- Fix mySQL Error Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock ERROR 2002 HY000
- [Fix] MySQL No database selected - ERROR 1046 (3D000)
More Posts:
- How to upgrade pip/pip3 package installer for Python - PIP
- How to Save Eclipse console logs in external log file - Eclipse
- zsh hello world example - Linux
- How to repeat background image in Android Activity - Android
- #HappyBirthdayJimin trending Happy Birthday Jimin BTS Army - BTS
- import servlet API to eclipse project (javax.servlet cannot be resolved error) - Java
- Disabling Spell Check in Android Studio - Android-Studio
- [Solved] Notepad++ Menu Bar Missing - NotepadPlusPlus