Re: Add Missing From?

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)