UPDATE/DELETE … WHERE CURRENT OF

Informix®

Informix allows positioned UPDATEs and DELETEs with the "WHERE CURRENT OF cursor" clause, if the cursor has been DECLARED with a SELECT ... FOR UPDATE statement.

Oracle® MySQL and MariaDB

MySQL and MariaDB do not support UPDATE/DELETE with the WHERE CURRENT OF cursor clause.

Solution

UPDATE/DELETE ... WHERE CURRENT OF is not supported by MySQL; review your code for occurrences.