Re: How to delete 3 months old records in my database?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: PHP Mailinglist <php-general@xxxxxxxxxxxxx>
Subject: Re: How to delete 3 months old records in my database?
From: Karl-Arne Gjersøyen <karlarneg@xxxxxxxxx>
Date: Fri, 2 Aug 2013 13:02:10 +0100
In-reply-to: <CAFY+RiEwXEgQSC5kw6+uvP3KEurTqMR-Tx=2k3uXb2E0Jm3-DA@mail.gmail.com>

2013/8/2 Dušan Novaković <ndusan@xxxxxxxxx>

> $query = "DELECT FROM `__table_name__` WHERE `__date__` BETWEEN NOW() -
> INTERVAL 3 MONTH AND NOW()"
>

This delete everything from now and 3months backwards. I want to store 3
months from now and delete OLDER than 3 months old records.

Karl

Follow-Ups:
- Re: How to delete 3 months old records in my database?
  - From: Simon Schick

References:
- How to delete 3 months old records in my database?
  - From: Karl-Arne Gjersøyen
- Re: How to delete 3 months old records in my database?
  - From: Dušan Novaković

Prev by Date: Re: How to delete 3 months old records in my database?
Next by Date: Re: How to delete 3 months old records in my database?
Previous by thread: Re: How to delete 3 months old records in my database?
Next by thread: Re: How to delete 3 months old records in my database?
Index(es):
- Date
- Thread

[Index of Archives] [PHP Home] [Apache Users] [PHP on Windows] [Kernel Newbies] [PHP Install] [PHP Classes] [Pear] [Postgresql] [Postgresql PHP] [PHP on Windows] [PHP Database Programming] [PHP SOAP]

Powered by Linux