Thanks, that did it! > -----Original Message----- > From: Peter Brawley [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 08, 2008 11:57 AM > To: Jeff Mckeon > Cc: mysql@lists.mysql.com > Subject: Re: delete query question > > Jeff, > > >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..) > > Like this (untested)? > > DELETE table1,table2 > FROM table1 t1 > JOIN table2 t2 ON t1.id=t2.ticket > WHERE t2.created < UNIX_TIMESTAMP( DATE_SUB( NOW(), INTERVAL 3 MONTH )) > ; > > PB > > ----- > > 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 > > > > > > > > > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
