little script for variable table_names

today=`date +'%y-%m-%d-%H-%M-%S'`
mon=`date +%m`_`date +%Y`
echo $mon
filename=push_report_$mon
echo $filename
mysqldump -h 10.130.0.53 -uroot -pmobi21 deploynew $filename >/data1/53_backup/dailybackp53/$filename$today.sql
##############################
mon=`date +%m`_`date +%Y`
echo $mon
lmon=`date --date="last month" +%m_%Y`
echo $lmon
mysql -uroot -ppaswd -e "drop view test.mo_reportlogs"
mysql -uroot -ppaswd -e "CREATE VIEW test.mo_reportlogs as SELECT reqtime,MSG,keyword_invoked FROM deploynew.mo_report_$mon
UNION SELECT reqtime,MSG,keyword_invoked FROM deploynew.mo_report_$lmon"

mysql -uroot -pgloadmin123 -e "CREATE VIEW `test`.`mo_reportlogs` SELECT deploynew.mo_report_$mon.reqtime,deploynew.mo_report_$mon.MSG,
deploynew.mo_report_$mon.keyword_invoked FROM deploynew.mo_report_$mon UNION SELECT reqtime,MSG,keyword_invoked FROM deploynew.mo_report_lmon"

##############################