Annulé

Create cron job to prune certain entries in MySQL

Hello,

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

Compétences : MySQL, Plesk

Voir plus : create table php, cron job mysql, mysql cron job views, cron job import mysql, mysql cron job

Concernant l'employeur :
( 49 commentaires ) Paris, France

N° du projet : #8507652

11 freelance ont fait une offre moyenne de 26 $ pour ce travail

harshatilva

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

30 $ USD en 1 jour
(10 Commentaires)
3.8
ShiaFirst

DONT AWARD PROJECT BEFORE DISCUSSION, its pretty simple for me but I have few questions to ask, knock me for further discussion, thank you!

30 $ USD en 1 jour
(1 Commentaire)
3.7
ithuang2014

A proposal has not yet been provided

54 $ USD en 2 jours
(4 Commentaires)
2.9
TenSidesDev

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

20 $ USD en 0 jours
(4 Commentaires)
3.1
turturkeykey

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.

25 $ USD en 0 jours
(1 Commentaire)
1.0
xpoh

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.

20 $ USD en 0 jours
(1 Commentaire)
1.0
jhoels1985

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

20 $ USD en 1 jour
(0 Commentaires)
0.0
RedMoonTech

Hi - I can get this project done for you immediately. Ready when you are. Thanks ............................................................................

25 $ USD en 0 jours
(0 Commentaires)
0.0
digitaldock

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

25 $ USD en 1 jour
(0 Commentaires)
0.0
alialraiyan

A proposal has not yet been provided

35 $ USD en 1 jour
(0 Commentaires)
0.0
ImranHossain1BD

A proposal has not yet been provided

27 $ USD en 1 jour
(0 Commentaires)
0.0
shamim7raj

ready to start , expert on this field

30 $ USD en 2 jours
(0 Commentaires)
0.0