http://www.perlmonks.org?node_id=1056377


in reply to CGI Program To Delete Old Data From MySQL Table?

My advice:

delete from <tablename>;

where <tablename> is the name of your table. Then all rows older than 60 days are deleted.

McA

Replies are listed 'Best First'.
Re^2: CGI Program To Delete Old Data From MySQL Table?
by blue_cowdawg (Monsignor) on Sep 30, 2013 at 17:44 UTC

    drop database <name>;
    is much more efficient. :-D


    Peter L. Berghold -- Unix Professional
    Peter -at- Berghold -dot- Net; AOL IM redcowdawg Yahoo IM: blue_cowdawg
Re^2: CGI Program To Delete Old Data From MySQL Table?
by talexb (Chancellor) on Sep 30, 2013 at 15:50 UTC

    I wouldn't recommend running delete from <tablename>; -- that's going to delete everything from the table, leaving you with nothing.

    Alex / talexb / Toronto

    Thanks PJ. We owe you so much. Groklaw -- RIP -- 2003 to 2013.

      that's going to delete everything from the table

      Yes, including the records older than 60 days. The aim will have been reached. ;-)

        I'm happy to see that at least one Monk has some kind of humor. I forgot the irony tags. But with this kind of asking you can only get angry or sarcastic, IMO.

        Best regards
        McA