from sqlalchemy import create_engine
engine = create_engine(
'mysql+pymysql://user:password@1.1.1.1:3306')
con = engine.connect()
报错:
Background on this error at: http://sqlalche.me/e/e3q8
【解决方法】
engine = create_engine(
'mysql+pymysql://user:password@1.1.1.1:3306/database?charset=utf8')
con = engine.connect()
- 另一个需要注意的地方:
Navicat 创建的数据库默认字符是
需要将字符集修改为utf-8