首页 > 数据库技术 > 详细

django:ySQL Strict Mode is not set for database connection 'default'

时间:2018-12-11 23:59:00      阅读:530      评论:0      收藏:0      [点我收藏+]

?: (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.djangoproject.com/en/2.1/ref/databases/#mysql-sql-mode

增加黄色配件的配置:

DATABASES = {
‘default‘: {
# ‘ENGINE‘: ‘django.db.backends.sqlite3‘,
# ‘NAME‘: os.path.join(BASE_DIR, ‘db.sqlite3‘),
‘ENGINE‘: ‘django.db.backends.mysql‘,
‘NAME‘: ‘erebus‘,
‘USER‘: ‘root‘,
‘PASSWORD‘: ‘root‘,
‘HOST‘: ‘127.0.0.1‘,
‘PORT‘: ‘3306‘,
‘OPTIONS‘: {
"init_command": "SET sql_mode=‘STRICT_TRANS_TABLES‘",
}

}
}



参考:https://www.jianshu.com/p/bc41a8bf9d9b

django:ySQL Strict Mode is not set for database connection 'default'

原文:https://www.cnblogs.com/shengulong/p/10105248.html

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