MariaDB Error 1175 – ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE

In this post, you’ll learn more about the MariaDB Error 1175 ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE with the details of the error message and why you receive this error

Maria DB Error Description

MariaDB Error 1175 – ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE with the sqlState HY000

Error Description for the MariaDB Error ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE

You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column