python3 manage.py migrate：?: (mysql.W002) MySQL Strict Mode is not set for database connection 'defa...

weixin_30906425

于 2019-08-06 23:55:00 发布

阅读量640

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 python

原文链接：http://www.cnblogs.com/gwklan/p/11312649.html

本文详细介绍了如何解决在Django项目中使用MySQL数据库时出现的Strict Mode未设置警告。通过在settings.py文件中修改DATABASES配置，加入'init_command'参数来启用Strict Mode，确保数据插入操作的数据完整性和一致性。

WARNINGS:
?: (mysql.W002) MySQL Strict Mode is not set for database connection 'default'
        HINT: MySQL's Strict Mode fixes many data integrity problems in MySQL, such as data truncation upon insertion, by escalating warnings into errors. It is strongly recommended you activate it. See: https://docs.djangoprojec
t.com/en/dev/ref/databases/#mysql-sql-mode

解决办法：settings.py文件夹加入DATABASES['OPTIONS']['init_command'] = "SET sql_mode='STRICT_TRANS_TABLES'"

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'django_test',
        'USER':'root',
        'PASSWORD':'',
        'HOST':'localhost',
        'PORT':'3306',
        #下面是新加入的
        'OPTIONS':{
            'init_command':"SET sql_mode='STRICT_TRANS_TABLES'",
            'charset':'utf8mb4',
        },
    }
}