Page 1 of 1

Auto Deleting a MySql table at month end with php

Posted: Fri Mar 05, 2010 3:03 am
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 ????

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

Posted: Fri Mar 05, 2010 3:13 am
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).

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

Posted: Fri Mar 05, 2010 3:18 am
by nithinkk
Can you tell me how to do it ?