Workaround for MySQL’s “can’t specify target table for update in FROM clause” Error

In MySQL, you cannot do this: The UPDATE statement will raise an error as follows: SQL Error [1093] [HY000]: You can’t specify target table ‘t’ for update in FROM clause People have considered this to be a bug in MySQL for ages, as most other RDBMS can do this without any issues, including MySQL clones: … Continue reading Workaround for MySQL’s “can’t specify target table for update in FROM clause” Error →

from Java, SQL and jOOQ. https://ift.tt/3gpGRf1
via IFTTT