List:General Discussion« Previous MessageNext Message »
From:Jeff Mckeon Date:July 8 2008 3:35pm
Subject:RE: delete query question
View as plain text  

> -----Original Message-----
> From: Ian Simpson [mailto:ians@stripped]
> Sent: Tuesday, July 08, 2008 11:27 AM
> To: Jeff Mckeon
> Cc: mysql@stripped
> Subject: Re: delete query question
> 
> If the tables are InnoDB, you could temporarily set up a foreign key
> relationship between the two, with the 'ON DELETE CASCADE' option.
> 

Nope, MyISAM...

> On Tue, 2008-07-08 at 11:14 -0400, Jeff Mckeon wrote:
> > I think this is possible but I'm having a total brain fart as to how
> to
> > construct the query..
> >
> > Table2.ticket = table1.ID
> >
> > Table2 is a many to 1 relationship to table1
> >
> > I need to delete all records from table1 where created <
> > unix_timestamp(date_sub(now(), interval 3 month))
> > And all rows from table2 where Table2.ticket = Table1.ID (of the
> deleted
> > rows..)
> >
> > Can't this be done in one query? Or two?
> >
> > Thanks,
> >
> > Jeff
> >
> >
> >
> >
> --
> Ian Simpson
> System Administrator
> MyJobGroup
> 
> This email may contain confidential information and is intended for the
> recipient(s) only. If an addressing or transmission error has
> misdirected this email, please notify the author by replying to this
> email. If you are not the intended recipient(s) disclosure,
> distribution, copying or printing of this email is strictly prohibited
> and you should destroy this mail. Information or opinions in this
> message shall not be treated as neither given nor endorsed by the
> company. Neither the company nor the sender accepts any responsibility
> for viruses or other destructive elements and it is your responsibility
> to scan any attachments.

Thread
delete query questionJeff Mckeon8 Jul
  • Re: delete query questionIan Simpson8 Jul
    • RE: delete query questionJeff Mckeon8 Jul
      • RE: delete query questionIan Simpson8 Jul
  • Re: delete query questionPeter Brawley8 Jul
    • RE: delete query questionJeff Mckeon8 Jul