More than 3 years have passed since last update.

WARNING:MySQL Strict Mode is not set for database connection 'default'の改善方法

Python
Django
MySQL

Posted at 2019-09-10

　(mysql.W002) MySQL Strict Mode is not set for database connection 'default'が出た時の対処法

settings.pyのDATABASESのdefaultにOPTIONSを追加する。

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'my_database',
        'OPTIONS': {
            'init_command': "SET sql_mode='STRICT_TRANS_TABLES'",
        },
    }
}

参考文献

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up