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
Dear All,
I have the following two system variable set in my MySQL configuration file
under mysqld section. But I am not fully understand what the two variable
internally does.
innodb_rollback_on_timeout=1
innodb_lock_wait_timeout=600
Any help will be appreciated.
Thanks for Your Time
Mohan L
erday storage
bases on date .Here id is same. I am new to witting mysql query (learning).
I think this can be done using sub query. any help will be really
appreciated .
Thanks & Rg
Mohan L