python按月分表

fdhfgh

d = GetDayMonth()　　table_name = sys.argv[1]
　　first_day_month = d.getFirstDayOfLastMonth(1)
　　last_day_month = d.getLastDayOfLastMonth(1)
　　last_3day_month = d.getLastDayOfLastMonth(3)
　　last_month = d.getLastMonth(1)
　　mysql_exec = MysqlExe('127.0.0.1',3306,'root','XXXX','guanba_data')
　　sql_create = "create table guanba_data.%s_%s  like guanba_data.%s"%(table_name,last_month,table_name)
　　sql_insert = "insert into guanba_data.%s_%s select * from guanba_data.%s where create_time >= unix_timestamp('%s 00:00:00') and create_time <= unix_timestamp('%s 23:59:59')"%(table_name,last_month,table_name,first_day_month,last_day_month)
　　sql_del = "delete from guanba_data.%s where  create_time <= unix_timestamp('%s 23:59:59')"%(table_name,last_3day_month)
　　mysql_exec.Creat_table(sql_create)
　　mysql_exec.Creat_table(sql_insert)
　　mysql_exec.Creat_table(sql_del)