with self.duengine.connect() as conn:
for i in range(100):
sql = "select user_id,duration,subject_1,item_id,Date(from_unixtime(create_time)) as create_time from `t_exer_record_{}` where channel=1".format(
str(i))
if i == 0:
df = pd.read_sql(sql, conn)
else:
df1 = pd.read_sql(sql, conn)
df = pd.concat([df1, df], ignore_index=True, sort=True)
mysql unixtime 直接取日期
最新推荐文章于 2023-12-21 17:22:11 发布