python
星辰_mya
好好学习,天天向上
展开
-
python拼接sql到文件
#!/usr/bin/python# -*- coding: UTF-8 -*-import pymysqlimport datetimeimport timeimport re,string def update_time_exe(): zone_list = find_update_time_rows() sql = "update plu set flipagv_max= %d,volume= %d WHERE plu_code= %s;" co...原创 2021-09-22 19:54:13 · 423 阅读 · 0 评论 -
批量更新python
今天有点尴尬,欸~先写个python吧 #!/usr/bin/python# -*- coding: UTF-8 -*-import pymysqlimport datetimeimport timeimport re,string #替换为**……………………def update_time_exe(): zone_list = find_update_time_rows() db = pymysql.connect(host=host, user=mysql_原创 2021-07-19 13:52:40 · 255 阅读 · 3 评论 -
python将原合并的字段作为单列存储
原来我们的表是这样式儿重构我想变成单列:这样式儿的import pymysqlfrom datetime import datetimeimport jsonfrom collections import namedtupleimport timehost = "1.1.1.1"mysql_user_name = "readonly"mysql_pwd = "some"mysql_warebasic_table = "db"now = datetime.now().原创 2021-05-11 17:38:02 · 89 阅读 · 0 评论 -
python批量修改数据库字段类型
#首先这个代码没有提取不够简练#!/usr/bin/python# -*- coding: UTF-8 -*-import pymysqlimport datetimeimport timeimport re,stringhost = "19.206.25.24"mysql_user_name = "root"now = datetime.datetime.now()now_timestamp = int(time.time())def update_create_time..原创 2021-01-25 18:14:18 · 897 阅读 · 5 评论
分享