Workaround for MySQL’s “can’t specify target table for update in...

σε πρόσθεσε στο Coding

2025-05-31 20:25:37 -

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

jOOQ workaround for "can't specify target table for update in FROM clause" In MySQL, you cannot do this: create table t (i int primary key, j int); insert into t values (1, 1); update t set j = (select max(j) from t) + 1; 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...

0 Σχόλια 0 Μοιράστηκε 307 Views 0 Προεπισκόπηση