maria-discuss team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

Hi, Rhys.Campbell!

On Jul 27, Rhys.Campbell@xxxxxxxxxxxx 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@xxxxxxxxxxx