Posted by mmckeon@gmail.com on 11/14/06 14:23

Can you use temporary tables to store your data that is going to
expire? If so these tables are good for the life of the connection and
may be useful for what you are doing with your records that expire. You
can even create one that is just like one of your "real" table:

create temporary table IF NOT EXISTS tmpMyTableCopy LIKE tblMyTable

Jerry Stuckle wrote:
> merianosnikos@gmail.com wrote:
> > Is a very good idea but i think that somebody or something must fire
> > this event . . . Is it posible to be start by it self ? ? ?
> >
> > For example i like to meka a table like this :
> >
> > $col_a | col_b | col_. . . | col_n | col_expire_date
> >
> > When the expire date is the current date delete the record.
> >
> > Thanks a lot . . . :D
> >
>
> Just set up a cron job to run once a day and deletes anything with an
> expiration date of today or before.
>
> It's one of the things cron jobs are designed for!
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex@attglobal.net
> ==================

[Back to original message]