![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
这个作者很懒,什么都没留下…
展开
-
python读取xml文档插入数据库并重命名xml进行判断是否存库
from xml.dom.minidom import parse import xml.etree.ElementTree as ET import re,os,datetime from loguru import logger import pymysql conn = pymysql.connect(host='localhost', user='root', password='',原创 2020-06-19 15:28:00 · 302 阅读 · 0 评论 -
读取excel数据存储到mysql并进行重命名
import pandas as pd import pymysql import os conn = pymysql.connect(host=’…’, user=’…’, password=’…’, db=’…’, charset=‘utf8’) cursor = conn.cursor() def save_excel(): print(‘开始查找Excel文件夹下面文件’) folder_num = os.listdir(r’Excel\’) if folder_num is []: print(‘原创 2020-06-19 15:10:51 · 206 阅读 · 0 评论