import pymysql import csv import codecs def get_conn(): db = pymysql.connect(host="12xxxx",port=3306, user="root",password="13xxx", db="pydata201806",charset="utf8") return db def insert(cur, sql, args): try: cur.execute(sql, args) except Exception as e: print(e) db.rollback() def read_csv_to_mysql(filename): with codecs.open(filename=filename, mode='r', encoding='utf-8') as f: reader = csv.reader(f) head = next(reader) print(head) conn = get_conn() cur = conn.cursor() sql = 'insert into tb_csv values(%s,%s,%s,%s,%s,%s,%s,%s,%s)' for item in reader: # if item[1] is None or item[1] == '': # item[1]作为唯一键,不能为null # continue args = tuple(item) print(args) insert(cur, sql=sql, args=args) conn.commit() cur.close() conn.close() if __name__ == '__main__': read_csv_to_mysql(r"E:\results.csv")
用python将csv文件导入mysql
最新推荐文章于 2024-08-05 17:20:21 发布