Flask MySql数据库警告处理

1：

...\venv\lib\site-packages\flask_sqlalchemy\__init__.py:794: FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future.  Set it to True or False to suppress this warning.
  'SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and '

解决方法：

# 配置文件中新增
SQLALCHEMY_TRACK_MODIFICATIONS = True

 

2：

...\venv\lib\site-packages\pymysql\cursors.py:170: Warning: (1366, "Incorrect string value: '\\xD6\\xD0\\xB9\\xFA\\xB1\\xEA...' for column 'VARIABLE_VALUE' at row 518")
  result = self._query(query)

解决方法：

# 安装mysql官方驱动
pip install mysql-connector-python
# 配置文件
SQLALCHEMY_DATABASE_URI = 'mysql+mysqlconnector://root:xxx@@localhost:3306/flask?charset=utf8'