how to know whether data is 6 months old or not in mysql 4.1 on fc3

• To: For users of Fedora Core releases <fedora-list@xxxxxxxxxx>
• Subject: how to know whether data is 6 months old or not in mysql 4.1 on fc3
• From: Ankush Grover <ankush174@xxxxxxxxx>
• Date: Tue, 23 Aug 2005 18:54:28 +0530
• Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=ahqoDIPA51v4jf159IcteAKoEZyWYDEqVzeu9svoUh98x0XOMzKQ7syW0vA3jgRvRWz+uFJXznwrdWo5nNWIASootG4Q1TqSKsN2b/+4S6S4d8FYl5VCP/8EogPgx99Wrwqdx0E/lin0PVlHt6kogUc9gqEYHhl9egEXCnn88Ns=
• List-archive: <https://www.redhat.com/archives/fedora-list>
• List-help: <mailto:[email protected]?subject=help>
• List-id: For users of Fedora Core releases <fedora-list.redhat.com>
• List-post: <mailto:[email protected]>
• List-subscribe: <http://www.redhat.com/mailman/listinfo/fedora-list>, <mailto:[email protected]?subject=subscribe>
• List-unsubscribe: <http://www.redhat.com/mailman/listinfo/fedora-list>, <mailto:[email protected]?subject=unsubscribe>
• Reply-to: For users of Fedora Core releases <fedora-list@xxxxxxxxxx>

hey friends,

I am using FC3 with mysql 4.1.I want to know is there anyway to know
which data is 3 months old or 6 months old in mysql.Actually i want to
move the data which is 6 months or more older from a database to
another database.

There are about 140 tables in that database and in many tables there
is no date field so difficult to know which data is greater than or
equal to  6 months old or less then 6 months old.

Please help me.

Thanks & Regards

Ankush Grover

• Prev by Date: Re: Printing from WinXP to cups running under FC4
• Next by Date: Re: Printing from WinXP to cups running under FC4
• Previous by thread: Printing from WinXP to cups running under FC4
• Next by thread: hp pavilion 4900 series laptop
• Index(es):
  • Date
  • Thread