數(shù)據(jù)庫插入警告
改了好多，一直都不行，老師這個坑有點多啊
Pertty宅特悶
2020-05-02
1 回答
舉報
0/150
提交
取消
2020-06-29
3-1 運行代碼連接數(shù)據(jù)庫創(chuàng)建數(shù)據(jù)表時報警告：Warning: (1366, "Incorrect string value: '\\xD6\\xD0\\xB9\\xFA\\xB1\\xEA...' for column 'VARIABLE_VALUE' at row 1")
解決：改用mysql-connector-python驅動。1、安裝mysql-connector-python驅動：pip install mysql-connector-python ?2、修改代碼engine = create_engine("mysql+pymysql://root:123456@127.0.0.1:3306/lagou?charset=utf8mb4") ?改為：engine = create_engine("mysql+mysqlconnector://root:123456@127.0.0.1:3306/lagou?charset=utf8mb4")