MySQL默认的sql mode怎么设置

发布日期： 2023-05-27 阅读量： 作者： ADMIN

SQL mode

mysql 5.7默认的sql mode包含only_full_group_by, strict_trans_tables, no_zero_in_date, no_zero_date, error_for_division_by_zero, no_auto_create_user, and no_engine_substitution。

这是MySQL官网的原文描述：“These modes were added to the default SQL mode in MySQL 5.7: The ONLY_FULL_GROUP_BY and STRICT_TRANS_TABLES modes were added in MySQL 5.7.5. The NO_AUTO_CREATE_USER mode was added in MySQL 5.7.7. The ERROR_FOR_DIVISION_BY_ZERO, NO_ZERO_DATE, and NO_ZERO_IN_DATE modes were added in MySQL 5.7.8. For additional discussion regarding these changes to the default SQL mode value, see SQL Mode Changes in MySQL 5.7.”

show sql mode

SELECT @@GLOBAL.sql_mode;

SELECT @@SESSION.sql_mode;

上一篇: dedecms的运行环境是什么

下一篇: C#开发微信门户及应用微信现金红包的封装及使用

MySQL默认的sql mode怎么设置

随便看看