Auto Deleting a MySql table at month end with php

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
nithinkk
Forum Commoner
Posts: 55
Joined: Sat Nov 28, 2009 7:57 am

Auto Deleting a MySql table at month end with php

Post by nithinkk »

Hi guys,

I want to delete a particular table from Mysql database at month end with PHP. I dont know whether its possible or not.....i want some suggestions from your end. I dont want to manually delete the table at the end of Month. Can PHP do that ????
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: Auto Deleting a MySql table at month end with php

Post by Christopher »

You can call a PHP script from a cron job. The PHP script can connect with the database and execute any SQL statements you want -- such as deleting a database (or all records in it).
(#10850)
nithinkk
Forum Commoner
Posts: 55
Joined: Sat Nov 28, 2009 7:57 am

Re: Auto Deleting a MySql table at month end with php

Post by nithinkk »

Can you tell me how to do it ?
Post Reply