All pastes #636103 Raw Edit

Miscellany

public text v1 · immutable
#636103 ·published 2007-07-27 16:51 UTC
rendered paste body
mysql> delete from quotes2
    ->  where id in (
    ->          select quotes2.id from quotes2
    ->                  join quotes on quotes2.quote = quotes.quote);
ERROR 1093 (HY000): You can't specify target table 'quotes2' for update in FROM
clause