|
#!/usr/bin/env python
# _*_ conding:utf-8 _*_
import sys
import os
import time
import datetime
import MySQLdb
today=datetime.date.today()
oneday=datetime.timedelta(days=1)
yesterday=today-oneday
yes_last=datetime.datetime.strftime(yesterday,"%Y%m%d")
#print yes_last
#print c_time
try:
conn1=MySQLdb.connect(host='192.168.1.108',user='dlan',passwd='root123',port=3306,db='aa')
cur1 = conn1.cursor()
aa2 = "create table aa_" + yes_last + " " + "as" + " " + "select * from test" + " " + "where" + " " + "date_format" + "(ti,'%Y%m%d')" + "=" + yes_last
old_del = "delete from test" + " " + "where" + " " + "date_format" + "(ti,'%Y%m%d')" + "=" + yes_last
cur1.execute(aa2)
cur1.execute(old_del)
conn1.commit()
cur1.close()
conn1.close()
except MySQLdb.Error,e:
print "Could not connect to MySQL server",e
|
|
|