import pymysqlimport csvimport codecsdef get_conn():    conn = pymysql.connect(host='localhost', port=3306, user='root', passwd='', db='wealth', charset='utf8')    return conndef insert(cur, sql, args):    cur.execute(sql, args)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)        conn = get_conn()        cur = conn.cursor()        sql = 'insert into csv values(%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__':    print("ceshi")    #read_csv_to_mysql('d:\\cardno.csv')    #字符串转16进制    print(int('0x60278be3', 16))    #数字转字符串    str(16)

使用注意

csv文本编码格式为utf-8，如果不是可以用vscode打开转换文本编码csv有几个字段，就用mysql建立几个字段，数据类型为varchar，修改上述代码中对应的sql语句即可。