課程
/后端開發(fā)
/Python
/Python爬蟲實(shí)戰(zhàn)數(shù)據(jù)可視化分析
改了好多，一直都不行，老師這個(gè)坑有點(diǎn)多啊
2020-05-02
源自：Python爬蟲實(shí)戰(zhàn)數(shù)據(jù)可視化分析 3-1
正在回答
3-1 運(yùn)行代碼連接數(shù)據(jù)庫創(chuàng)建數(shù)據(jù)表時(shí)報(bào)警告：Warning: (1366, "Incorrect string value: '\\xD6\\xD0\\xB9\\xFA\\xB1\\xEA...' for column 'VARIABLE_VALUE' at row 1")
解決：改用mysql-connector-python驅(qū)動(dòng)。1、安裝mysql-connector-python驅(qū)動(dòng)：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")
舉報(bào)
網(wǎng)站數(shù)據(jù)收集分析必備技能
1 回答數(shù)據(jù)庫連接
1 回答創(chuàng)建數(shù)據(jù)庫表時(shí)出現(xiàn)問題
1 回答大壯老師，你還有當(dāng)時(shí)的爬下來的招聘數(shù)據(jù)嗎？可以給我嗎？
1 回答apply_async里面的函數(shù)不執(zhí)行
Copyright ? 2025 imooc.com All Rights Reserved | 京ICP備12003892號(hào)-11 京公網(wǎng)安備11010802030151號(hào)
購課補(bǔ)貼聯(lián)系客服咨詢優(yōu)惠詳情
慕課網(wǎng)APP您的移動(dòng)學(xué)習(xí)伙伴
掃描二維碼關(guān)注慕課網(wǎng)微信公眾號(hào)
2020-06-29
3-1 運(yùn)行代碼連接數(shù)據(jù)庫創(chuàng)建數(shù)據(jù)表時(shí)報(bào)警告：Warning: (1366, "Incorrect string value: '\\xD6\\xD0\\xB9\\xFA\\xB1\\xEA...' for column 'VARIABLE_VALUE' at row 1")
解決：改用mysql-connector-python驅(qū)動(dòng)。1、安裝mysql-connector-python驅(qū)動(dòng)：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")