In article <[EMAIL PROTECTED]>, Tom Lane <[EMAIL PROTECTED]> writes:
> Robert Treat <[EMAIL PROTECTED]> 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) ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
