Mysql：Changes in MySQL 5.7.22 (2018-04-19, General Availability)：These compatibility 【SQL modes】 are now deprecated and will be removed

Changes in MySQL 5.7.22 (2018-04-19, General Availability)

Deprecation and Removal Notes

• These compatibility SQL modes are now deprecated and will be removed in MySQL 8.0: DB2, MAXDB, MSSQL, MYSQL323, MYSQL40, ORACLE, POSTGRESQL, NO_FIELD_OPTIONS, NO_KEY_OPTIONS, NO_TABLE_OPTIONS. These deprecations have two implications:

  • Assigning a deprecated mode to the sql_mode system variable produces a warning.

  • With the MAXDB SQL mode enabled, using CREATE TABLE or ALTER TABLE to add a TIMESTAMP column to a table produces a warning.

  Statements that use these deprecated SQL modes may fail when replicated from a MySQL 5.7 master to a MySQL 8.0 slave, or may have different effects on master and slave. To avoid such problems, applications that use the modes deprecated in MySQL 5.7 should be revised not to use them.