Hi ,
Have a look at database information_schema.TABLES:
SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA='';
As long as your MySQL version is >= 5.1, you don't need a cron script,
you can use the MySQL scheduler, create a stored procedure that will run
each month. You'll need to use pr
On Fri, Nov 18, 2011 at 1:32 PM, a bv wrote:
> Hi,
> I have a linux box running mysql plus phpmyadmin which has tables
> getting montly data and when a new month starts a new table is
> created. I want to store only 2 years of data so when a new month
> starts i need to drop the table which b
Hi,
I have a linux box running mysql plus phpmyadmin which has tables
getting montly data and when a new month starts a new table is
created. I want to store only 2 years of data so when a new month
starts i need to drop the table which became the data container of 2
years previous data. So to
