On 8/9/2004 12:53 PM, Josh Berkus wrote:
People,
> DELETE FROM target_tbl USING other_tbls WHERE ...
Feels much more understandable. The second FROM looks like a hickup.
Yes, although imagine:
DELETE FROM staff USING users JOIN logons USING (user_id) WHERE last_logon < ( now() - '6 months');
Not as bad as FROM, but still a bit baffling to look at. Still, I can't think of anything else that wouldn't require inventing a new reserved word.
What about
DELETE FROM staff JOIN users ...
then?
Oh, and MySQL's "multi-table deletes": PLEASE tell me that's not SQL-standard.
Yes, not standard.
Jan
-- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== [EMAIL PROTECTED] #
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
