擅长:python、mysql、java
<p><a href="https://docs.djangoproject.com/en/1.11/ref/databases/#mysql-sql-mode" rel="nofollow noreferrer">https://docs.djangoproject.com/en/1.11/ref/databases/#mysql-sql-mode</a></p>
<p>设置sql模式</p>
<blockquote>
<p>From MySQL 5.7 onwards and on fresh installs of MySQL 5.6, the default
value of the sql_mode option contains STRICT_TRANS_TABLES. That option
escalates warnings into errors when data are truncated upon insertion,
so Django highly recommends activating a strict mode for MySQL to
prevent data loss (either STRICT_TRANS_TABLES or STRICT_ALL_TABLES).</p>
<p>If you need to customize the SQL mode, you can set the sql_mode
variable like other MySQL options: either in a config file or with the
entry 'init_command': "SET sql_mode='STRICT_TRANS_TABLES'" in the
OPTIONS part of your database configuration in DATABASES.</p>
</blockquote>