MYSQL Cronjob script

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

Write a MYSQL quiry and delete unwanted content. Then write cronjob to automate it.

Basically something like this:

SELECT * FROM `tableX` WHERE `fieldY` LIKE '%contentZ%'

then DELETE FROM 'database' 'contentZ'

Then a Cronjob to run it every X minutes.

MySQL PHP

Project ID: #14287837

About the project

37 proposals Remote project Active 6 years ago

Awarded to:

rajeshsonisl

Hello! Quick and easy. Just send CPanel access. With 98% to 99% completion rate, 1000+ successfully completed projects, and a 4.99 reputation (maximum possible, 5.0) (can be verified on my profile page https://ww More

$20 USD in 0 days
(931 Reviews)
8.6

37 freelancers are bidding on average $25 for this job

dagdya99

Hi, I'm interested to work on your project, I will start project immediately Please let me know if you require any detailed information. Waiting for your reply Thanks Dev

$35 USD in 1 day
(423 Reviews)
7.6
dkokmadis

A proposal has not yet been provided

$33 USD in 1 day
(278 Reviews)
6.8
shihan033010

A proposal has not yet been provided

$15 USD in 1 day
(314 Reviews)
6.8
csajit

HELLO THERE, Over 200+ Positive Reviews. Over 90% Completion Rate. 5 Star Rating. 8+ Years of experience in PHP/MYSQL I AM INTERESTED IN WORKING ON THIS PROJECT. PLEASE CHECK MY REVIEWS AND THEN DECIDE ON More

$20 USD in 0 days
(275 Reviews)
6.8
rajdeepa555

Hello Sir, I have good experience in linux and mysql, so i can write this query of deleting some selected content. and then setup a cron job which will run every minute. please correct me if i am wrong. Thanks, More

$30 USD in 1 day
(43 Reviews)
6.1
Sonicoders

I have more than 3 years experience in the web development I can provide you the solution quickly inbox me,we can talk more over chat.

$55 USD in 1 day
(135 Reviews)
6.1
articontech

A proposal has not yet been provided

$25 USD in 1 day
(94 Reviews)
5.9
Softanz2

Dear sir, I am expert in write a cron script and setup cron for website. i already these tasks for many of the my client websites. I have 10+ years experienced PHP developer. After reading your project details,I am int More

$30 USD in 1 day
(21 Reviews)
5.0
CBabbage

Hi there, hope you are doing good, i can create the sql query for you for the selective deletion and putting it into a cron. one thing though is if the SQL is in the cron then you have to have the DB user and password More

$30 USD in 1 day
(50 Reviews)
5.2
phiona06

Hi! We can use event in MySQL: CREATE EVENT `testEvent` ON SCHEDULE EVERY X MINUTE DO BEGIN DELETE FROM `tableX` WHERE `fieldY` LIKE '%contentZ%'; END

$25 USD in 0 days
(22 Reviews)
4.5
djcarras

hi, i can help you with your project. send me more information about via freelancer.com chat. regards

$30 USD in 1 day
(14 Reviews)
4.1
player4zone

I understand that you need a cron job to query and delete unwanted data such that it should run in every X minutes. I have PHP, MYSQL, AJAX, JS experience. I can have a word with you and start doing it.

$25 USD in 1 day
(26 Reviews)
3.9
adminitpulp

Hello, I will write the code and create the cronjob now. I am here and we can have a discussion. Please ping me and have a discussion. I will start work on it now. Thanks, Tushar

$25 USD in 1 day
(18 Reviews)
4.4
victorxian

Hi my name is Victor and I live in Melbourne Australia. I work as a Linux System Engineer with 8 years experience in supporting Enterprise Linux environment. This should be done in less than an hour for you. Happy t More

$25 USD in 1 day
(3 Reviews)
1.8
syncromindperu

Hello Which is the hosting service that you use? I am able to start as soon as you say. Regards, Alejandro

$15 USD in 1 day
(2 Reviews)
1.5
HawkGuyIA

Very easy. I can do this for you tonight. Please PM me with the details.

$30 USD in 1 day
(2 Reviews)
1.1
ilatech

Hi, I'm a french software engineer, and I worked for 10 years for compagnies. Now I'm a freelancer. For your project, I am available from now, and for the time you want. If you have any questions do not hesita More

$25 USD in 2 days
(2 Reviews)
0.7
ashleysimpsonst

A proposal has not yet been provided

$10 USD in 1 day
(0 Reviews)
0.0
greengeckowebs

I'm a full stack web developer with experience in mysql queries and I have done a lot of cronjobs before so I think I will be the perfect developer for this job

$10 USD in 1 day
(0 Reviews)
0.0
Vashy

Experienced with both Linux and MySQL, this seems like a straightforward problem to solve. I can walk you through the code once I'm done with it as well.

$35 USD in 1 day
(0 Reviews)
0.0