#coding=utf-8 import MySQLdb import datetime db = MySQLdb.connect(host="localhost",user="root",passwd="123456",db="yuht",charset="utf8") cursor = db.cursor() string_sql="(" begin = datetime.date(2017,8,1) end = datetime.date(2019,7,31) l=[] d = begin delta = datetime.timedelta(days=1) su=0 while d <= datetime.date(2020,4,26): su=su+1 #print d.strftime("%Y-%m-%d") d += delta l.append(d) print su j = 0 for i in l[:len(l)-1]: j = j + 1 string_sql=string_sql+"PARTITION p%d VALUES LESS THAN (to_days('%s'))," % (j,i) string_sql=string_sql+"PARTITION p1000 VALUES LESS THAN (to_days('2020-04-27')))" print string_sql string2="(PARTITION p1 VALUES LESS THAN (to_days('2017-07-
mysql表使用python脚本建立数据表包含多个分区
最新推荐文章于 2023-03-13 14:39:06 发布