In article <5431.1092025741@sss.pgh.pa.us>,
Tom Lane <tgl@sss.pgh.pa.us> writes:
> Robert Treat <xzilla@users.sourceforge.net> writes:
>> Well, as yall have pointed out, the feature is not sql spec (for some
>> reason I thought it had been put in) so since the update syntax seems
>> quite similar to oracles, perhaps they can provide a pointer on delete
>> syntax as well? I can't seem to find my oracle syntax book, anyone
>> have one handy ?
> Didn't get any Oracle hits in a quick google, but I did find out that
> MySQL spells it USING:
> DELETE FROM target_tbl USING other_tbls WHERE ...
> This isn't a particularly compelling precedent seeing that (a) MySQL
> doesn't use our flavor of UPDATE syntax and (b) they only adopted the
> above in 4.0.2.
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)