panda写数据到mysql,出现以下错误:
pymysql.err.InternalError: (1366, "Incorrect string value: '\\xE6\\x8B\\xBF\\xE5\\xB7\\xA5...' for column `test`.`cleaned_gzdata`.`fullURL` at row 7765")
解决方法:
engine = create_engine('mysql+pymysql://root:123123@127.0.0.1:3306/test?charset=utf8') 将上一行的 charset=utf8 改为 charset=utf8mb4
问题解决!