首页 > 数据库技术 > 详细

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

时间:2019-08-07 01:40:11      阅读:133      评论:0      收藏:0      [点我收藏+]
WARNINGS:
?: (mysql.W002) MySQL Strict Mode is not set for database connection default
        HINT: MySQLs 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,
        },
    }
}

 

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

原文:https://www.cnblogs.com/gwklan/p/11312649.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!