You are here: Re: I need a "pruning" tool for MySQL « MySQL Databases « IT news, forums, messages
Re: I need a "pruning" tool for MySQL

Posted by Joseph Melnick on 06/26/05 18:27

Andy in NJ Wrote:

"Andy in NJ" <ADMIN at FLOTSERVER DOT NET> wrote in message
news:t8ednV3Qs-NASCDfRVn-2A@comcast.com...
>
> "Joseph Melnick" <jmelnick@jphp.com> wrote in message
> news:epydnQPwmtYXXSDfRVn-jg@rogers.com...
>> Does your table have a created OR modified field?
> <snip>
>
> I'm afraid this is beyond my expertise. I can log onto cpanel and go to
> PHPMyAdmin and run commands. I would load a certian table, which contains
> an entry for each player's name. In that table is a date, in Linux format,
> that says when it was last updated.

Run the first Query in PHPMyAdmin to get the list of Players that match your
criteria and change INTERVAL 30 DAY to the number of inactive days that
makes sense. This will give you a list of player_id's, and when they were
last modified.


SELECT a.player_id,MAX(a.modified)
FROM players a
WHERE DATE_ADD( FROM_UNIXTIME(a.modified),INTERVAL 30 DAY) < now()
GROUP BY a.player_id;

Get:
player_id modified
1 2005-01-01 12:00:00
5 2005-04-28 01:39:22
....
212 2004-12-31 23:59:59


then run this Query where player is in a comma separated list of
player_id's:

DELETE FROM stats WHERE player_id IN (1, 5, ....,212);


Joseph Melnick
JM Web Consultants
Toronto, Ontario, Canada
http://www.jphp.com/

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация