python解决SQLAlchemy+MySQL操作数据库时报警告Warning: (1366, "Incorrect string value: '\\xD6\\xD0\\xB9\\xFA\\xB1\\xEA...' for column 'VARIABLE_VALUE' at row 478") result = self._query(query)

解决方案:

1.安装mysql-connector-python驱动
	pip install mysql-connector-python
2.修改代码
	engine = create_engine("mysql+pymysql://root:password@localhost/my_db")
	改为:
	engine = create_engine("mysql+mysqlconnector://root:password@localhost/my_db")
posted @ 2020-02-23 11:31  MiaoQinHong  阅读(789)  评论(0编辑  收藏  举报