I have no problem understanding the syntax, or how to do what I want (at least after my first mistake). It is more about if this is a consistant grammar. For example, unix commands have the form "<verb> <src> <object>", except for "ln -s" (IMO).
>From a lexical view, I do not think the two forms are parallel. My question was, is this to be consistant with other sql constructs, or is it just the way it is? On Sun, 25 Jul 2004, Michael Stassen wrote: > The point is to distinguish between the tables which are joined to pick the > rows and the tables from which rows are to be deleted. You have 2 options: > > DELETE FROM t1 USING t1,t2 ... > > or > > DELETE t1 FROM t1,t2 ... > > Perhaps you are extrapolating from 'DELETE FROM t1...' to expect that the > second form should delete from both tables, but note that the second form is > not 'DELETE FROM t1,t2...', it's 'DELETE t1 FROM t1,t2...'. If you must > relate it to something, I'd suggest 'SELECT t1.* FROM t1,t2 ...' is the > natural parallel. > > Michael > _____ Douglas Denault http://www.safeport.com [EMAIL PROTECTED] Voice: 301-469-8766 Fax: 301-469-0601 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
