Hi, Rhys.Campbell! On Jul 27, [email protected] wrote: > Hi Sergei, > > Thanks for your response. Shouldn't this work? > > EXPLAIN DELETE uc FROM t1 AS uc > WHERE uc.id IN (SELECT p.id FROM t2 AS p WHERE p.account_id = 9999) > RETURNING uc.some_id; > > Or does that count in the definition of a multi-table delete? (I thought > not).
It does. See the manual: https://mariadb.com/kb/en/mariadb/delete/ Single table delete: DELETE FROM ... Multi-table detele: DELETE tables FROM Regards, Sergei Chief Architect MariaDB and [email protected] _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
