mysql表使用python脚本建立数据表包含多个分区

最新推荐文章于 2023-04-07 14:32:25 发布

小鱼人儿

最新推荐文章于 2023-04-07 14:32:25 发布

阅读量1.1k

点赞数

文章标签： python mysql 分区数据表

本文链接：https://blog.csdn.net/qq_25123119/article/details/76474607

版权

#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-