Hi all,

I want to use a single delete statement to delete records from multiple tables.

The MySQL manual appears to say that the following two statements are functionally identical.

DELETE a1, a2 FROM t1 AS a1 INNER JOIN t2 AS a2
WHERE a1.id=a2.id;

DELETE FROM a1, a2 USING t1 AS a1 INNER JOIN t2 AS a2
WHERE a1.id=a2.id;

Am i correct?

The only difference appears to be semantic and as such, i prefer the latter "DELETE FROM a1, a2 USING" syntax. It seems more natural.