MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: multi table delete
Posted by: Bob Field
Date: November 22, 2006 11:48AM 

DELETE m, i, l, n
FROM master   AS m
JOIN iostats  AS i ON m.id = i.id
JOIN loads    AS l ON i.id = l.id
JOIN nfsstats AS n ON l.id = n.id
WHERE m.epoch < UNIX_TIMESTAMP()-3600

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
multi table delete
bpontz
November 22, 2006 09:16AM
Re: multi table delete
Bob Field
November 22, 2006 11:48AM
Re: multi table delete
bpontz
November 22, 2006 12:56PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.