RE: Deleting the records from a table

2004-12-14 Thread Bob Showalter
Mallik wrote: > Hi Friends, > > I need a help from you in implementation of purging functionality. > I am given a hash of table(s), each having millions of records. i > need to delete those records keeping latest 5 days records in the > tables. > > I know the delete query like: delete from $tabl

RE: Deleting the records from a table

2004-12-14 Thread Mallik
December 14, 2004 5:02 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Deleting the records from a table Hi, It songs a funny solutions but... Create a TEMP table and insert latest 5 days data After delete the table and rename temp table José Pinto -Original Message- Fro

RE: Deleting the records from a table

2004-12-13 Thread Jenda Krynicky
From: Bob Showalter <[EMAIL PROTECTED]> > Mallik wrote: > > Hi Friends, > > > > I need a help from you in implementation of purging functionality. I > > am given a hash of table(s), each having millions of records. i need > > to delete those records keeping latest 5 days records in the tables. > >

RE: Deleting the records from a table

2004-12-13 Thread José Pedro Silva Pinto
Hi, It songs a funny solutions but... Create a TEMP table and insert latest 5 days data After delete the table and rename temp table José Pinto -Original Message- From: Mallik [mailto:[EMAIL PROTECTED] Sent: terça-feira, 14 de Dezembro de 2004 11:31 To: [EMAIL PROTECTED] Subject: Del