【填坑】python3 manage.py migrate:?: (mysql.W002) MySQL Strict Mode is not set for database connection 'default'
问题:
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': 'wanwen',
'USER':'root',
'PASSWORD':'',
'HOST':'127.0.0.1',
'PORT': '3306', # 数据库使用的端口
'OPTIONS':{'init_command':'SET sql_mode="STRICT_TRANS_TABLES",storage_engine=INNODB;'} #设置数据库为INNODB,为第三方数据库登录用
}
}
最新文章
- js中bind,call,apply方法的应用
- PHP生成日历数组,减少分页
- 【leetcode❤python】 165. Compare Version Numbers
- PHP Redis
- GLSL Entry point not found
- android switch控件的使用
- Android用户界面布局(layouts)
- java堆栈
- createDocumentFragment
- 84. 从视图索引说Notes数据库(下)
- Shell脚本之反引号【``】和 $()
- CodeForces346 C. Number Transformation II
- 忘记mysql密码时对密码进行更改
- 20190122 loop
- java 一些容易忽视的小点-控制语句
- Linux Ubuntu 安装、汉化、常用操作
- TensorFlow函数(二)tf.get_variable() 和 tf.Variable()
- node.js修改全局安装文件路径
- mysql使用数据库
- .NET类型转型的四种做法(转)