Re: Script need for dropping databases

2011-11-18 Thread Mohan L
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

innodb system variable

2011-03-29 Thread Mohan L
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

sub query to daily usage subtraction

2010-11-30 Thread 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