Harald Fuchs <hf0722x@protecting.net> writes:
> Actually, MySQL supports two different syntaxes for multi-table DELETEs:
> 1. DELETE t1,t2 FROM t1,t2,t3 WHERE t1.id=t2.id AND t2.id=t3.id;
> (introduced in MySQL 4.0.0)
> 2. DELETE FROM t1,t2 USING t1,t2,t3 WHERE t1.id=t2.id AND t2.id=t3.id;
> (introduced in MySQL 4.0.2)
Yeah. I ignored the first, as being so stupid that even the MySQL guys
soon realized what a bad idea it was ;-)
regards, tom lane