Strict mode and loose mode setting of MYQL

When you add an extra long article, the Content field of the article is captured by MySQL and inserted.

Debug: There is no problem with the SQL inserted by the program. Just gave a warning.

Problem reason: MySQL uses a loose mode, resulting in automatic interception. Brings trouble to debug,

Solution:

1, open MySQL strict mode, the development of good;

2, change the type of MySQL field
Open Strict mode:

By modifying the MySQL profile to find Sql-mode in the configuration file, modify this row to:

Sql-mode= "Strict_trans_tables,no_auto_create_user,no_engine_substitution"

If sql-mode= is not found, add it under [mysqld]