[MySQL][Resolved] mysql insensitive case update error 1175

 Source:

UPDATE libsys_user SET pwd = "123"

WHERE UPPER(user_id) = UPPER("sam");

Solution 1

Turn OFF "Safe Update Mode" temporary:

SET SQL_SAFE_UPDATES = 0;

UPDATE libsys_user SET pwd = "123"

WHERE UPPER(user_id) = UPPER("sam");

SET SQL_SAFE_UPDATES = 1;

Solution 2

Define the row limit and execute, limit update one record only:

UPDATE libsys_user SET pwd = "123"

WHERE UPPER(user_id) = UPPER("sam") LIMIT 1;

Reference:

https://stackoverflow.com/questions/11448068/mysql-error-code-1175-during-update-in-mysql-workbench