RE: delete, where, and subselects...

embre 2005 19:53 To: mysql@lists.mysql.com Subject: delete, where, and subselects... to quote the manual: Currently, you cannot delete from a table and select from the same table in a subquery. mysql> select * from paths where id>=(select max(ppathref)

delete, where, and subselects...

to quote the manual: Currently, you cannot delete from a table and select from the same table in a subquery. mysql> select * from paths where id>=(select max(ppathref) from paths); ++-++--+ | id | typeref | name | ppathref | ++-+--