Re: Script need for dropping databases

-database/ and you can also use something like : #!/bin/bash mysql dbnaneEOFMYSQL DROP table table_name; CREATE TABLE table_name; EOFMYSQL Thanks Rg Mohan L

innodb system variable

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

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