現(xiàn)象：
??今天寫了個insert mysql的python腳本丽啡，結(jié)果報錯了 報錯如下圖：
QQ圖片20190220170333.png
python版本
Python 3.6.6
解決辦法：
??使用mysql-connector-python包替代pymysql包孔祸；
??使用pip3安裝：
pip3 install mysql-connector-python
??修改腳本：
??原腳本：
#!/usr/bin/python3
# -*- coding:utf-8 -*-
import re
import pymysql as MySQLdb
def run_insert_sql(mysql_ip, database, insert_sql):
db = MySQLdb.connect(mysql_ip, 'root', 'root', database, charset='utf8' )
cursor = db.cursor()
try:
cursor.execute(insert_sql)
db.commit()
except:
db.rollback()
db.close()
??修改為：
#!/usr/bin/python3
# -*- coding:utf-8 -*-
import re
#import pymysql as MySQLdb
import mysql.connector as mysqlcon
def run_insert_sql(mysql_ip, db_name, insert_sql):
db = mysqlcon.connect(host = mysql_ip, user = 'root', password = 'root', database = db_name, charset='utf8' )
cursor = db.cursor()
try:
cursor.execute(insert_sql)
db.commit()
except:
db.rollback()
db.close()
??解決纷铣！
