txt导入mysql

import sysif len(sys.argv) != 3:    exit(-1)print('open file: <%s> use encoding <%s>'%(sys.argv[1], sys.argv[2]))import pymysqlcsdn_conn = pymysql.connect(host='localhost',                port=3306,                user='root',                passwd = 'xinwen',                db = 'csdn_visual02',                charset='utf8'                )with open(sys.argv[1], 'r', encoding=sys.argv[2], errors='ignore') as in_file , \        csdn_conn.cursor() as cur:    count = 0    for line in in_file:        count += 1        cols = line.strip('\n ').split(' # ')        print(cols)        cur.execute('insert into csdn_user(username, password, email) values(%s, %s, %s);',args=cols)        if count > 500:            csdn_conn.commit()            count = 0csdn_conn.commit()exit(1)