![](https://img-blog.csdnimg.cn/20201014180756757.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Python
zaws
1
展开
-
python sql executemany 执行慢的问题
python sql executemany 执行慢的问题环境 Python3.7.6 pymysql0.10.0这条sql使用executemany,只有一行数据时仍然执行执行很慢。query = """ INSERT into settlement.salary_data (start_dt, end_dt, belong_to, report_to, ... , create_time, update_time) VALUES(%(start_dt)s, %(end_dt)s, %原创 2020-09-17 09:01:44 · 2228 阅读 · 1 评论 -
Python 时间戳字符串转换
import time# 时间戳转为格式化字符串def timestamp_to_str(timestamp, format): time_tuple = time.localtime(timestamp) return time.strftime(format, time_tuple) # 格式化字符串转化为时间戳def str_to_timestamp(str_time, format): time_tuple = time.strptime(str_time原创 2020-09-25 23:04:22 · 687 阅读 · 0 评论