Jack Coxen wrote:
I had originally planned to use syntax similar to:
DELETE * FROM table_name WHERE `dtime` < [90 days ago]
delete * from table_name where to_days(now())-to_days(dtime) > 90
After the DELETE runs, I plan on running MYISAMCHK on the affected table.
Then I'll repeat both steps for a
:[EMAIL PROTECTED]
> Sent: Wednesday, August 20, 2003 6:07 AM
> To: MySQL List (E-mail)
> Subject: Delete questions and speed/safety issues
>
>
> I'm in the process of writing a Perl script to delete records
> out of a database when the records are more than 90 days old.
Original Message-
From: Michael S. Fischer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 1:43 PM
To: 'Jack Coxen'; 'MySQL List (E-mail)'
Subject: RE: Delete questions and speed/safety issues
It's quite possible you're using the wrong tool for the job.
her'; Jack Coxen; 'MySQL List (E-mail)'
Subject: RE: Delete questions and speed/safety issues
Switching to another database isn't really an option. I didn't write
the package and I'm not good enough to port it to another database or to
rewrite it for a multiple mach
I'm in the process of writing a Perl script to delete records out of a
database when the records are more than 90 days old. I'm running MySQL
version 4.0.12-standard. The db consists of around 620 MyISAM tables with
the following structure:
CREATE TABLE `ifInErrors_2` (
`id` int(11) NOT NULL d
