PHP MySQL

[merianosnikos@gmail.com]

Hello . . .

I need some help . . .

I have a question . . .

how can i delete from MySQL database table automatic expired records ?
? ?

One think is to make a service that deleting the expired records . . .

Any other method ? ? ?

Thanks a lot . . . :D

[Noodle]

Re: PHP MySQL


merianosnikos@g mail.com wrote:

Hello . . .
>
I need some help . . .
>
I have a question . . .
>
how can i delete from MySQL database table automatic expired records ?
? ?
>
One think is to make a service that deleting the expired records . . .
>
Any other method ? ? ?
>
Thanks a lot . . . :D

Depending on how your records become expired, you could try using a
mysql trigger.

http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html

[merianosnikos@gmail.com]

Re: PHP MySQL

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

[frothpoker]

Re: PHP MySQL

I would drop it in to a function call that you can embed in other
functions that will get called on a regular basis. E.g. when a new
user registers, as well as creating all of the information required for
recording that user in the database it should call housekeeping()

This way the functions will run on a regular basis.

Obiron

[Jerry Stuckle]

Re: PHP MySQL

merianosnikos@g mail.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@attgl obal.net
=============== ===

[mmckeon@gmail.com]

Re: PHP MySQL

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@g mail.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@attgl obal.net
=============== ===

[Jerry Stuckle]

Re: PHP MySQL

mmckeon@gmail.c om wrote:

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@att global.net
>>============= =====

>
>
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
>

(Top posting fixed)

The only problem with temporary tables is they go away at the end of the
connection. If he wants to use use them again, i.e. on a subsequent
page, they're gone.


--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===