python解决SQLAlchemy+MySQL操作数据库时报警告Warning: (1366, "Incorrect string value: '\xD6\xD0\xB9\xFA\xB1...

mac2022-06-30  86

解决方案

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")

 

详细文档可参考:https://www.jianshu.com/p/e09eb9cc2830

转载于:https://www.cnblogs.com/JentZhang/p/11576865.html

最新回复(0)