django：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 ac
tivate it. See: https://docs.djangoproject.com/en/3.0/ref/databases/#mysql-sql-mode
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'py_demo01',
'USER': 'root',
'PASSWORD': '123456',
'HOST': '127.0.0.1',
'PORT': '3306',
'OPTIONS': {
"init_command": "SET sql_mode='STRICT_TRANS_TABLES'",
}
}
}
增加 OPTIONS 项可解决
?: (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 ac
tivate it. See: https://docs.djangoproject.com/en/3.0/ref/databases/#mysql-sql-mode
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'py_demo01',
'USER': 'root',
'PASSWORD': '123456',
'HOST': '127.0.0.1',
'PORT': '3306',
'OPTIONS': {
"init_command": "SET sql_mode='STRICT_TRANS_TABLES'",
}
}
}
增加 OPTIONS 项可解决