Re: [Maria-discuss] Finicky syntax with RETURNING?

Hi, Rhys.Campbell! On Jul 27, Rhys.Campbell@swisscom.com 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 security@mariadb.org