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
: Deleting the records from a table 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

Deleting the records from a table

2004-12-13 Thread Mallik
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 $tableName where adddtm < today ? $n