I have a table in MYSQL database in Plesk that would need automatic pruning.
All entries in a table have a timestamp, I would like to have entries older than 72 hours automatically deleted every day.
You won't have access to the database, I will give you all details (screenshots) so you can create a php file and then tell me which command to enter in the Scheduled Task in Plesk.
Quite an easy job :)
11 freelance font une offre moyenne de $26 pour ce travail
Hi, I hope you are doing fine. I am new to freelancing but I have 4 to 5 year experience in designing and developing. I read your project description and would like to work with you. I will provide you 100% sa Plus
DONT AWARD PROJECT BEFORE DISCUSSION, its pretty simple for me but I have few questions to ask, knock me for further discussion, thank you!
Hello, I can do that for you, right now... I'm not busy and don't have anything else to do.. so if you interested.. Send me those screenshots I'll get right at it. Thanks, Alek
Hi, I think i can help you with this project. If awarded, i will deliver the file within 2 hours (debugging included). I hope we can collaborate together. Have a nice day.
Hello! I'm ready to help with this p roject. all I need from u is table names and field name with timestamp. Whill send u finished script in 30 minutes. Contact me to discuss details.
Hola amigo. Puedo ayudarte en este proyecto. tan solo tienes que indicarme cual es el nombre de tu base de datos. y la tabla específica qie requieres vaciar cada 72 horas. y yo te ayudaré a la creación de la tarea prog Plus
Hi - I can get this project done for you immediately. Ready when you are. Thanks ............................................................................
The SQL you need will be something like: DELETE FROM my_table_name WHERE my_date_column < DATE_SUB( NOW(), INTERVAL 72 HOUR ); You can make it executable without a PHP script as a simple BASH command line: ech Plus