当前位置:首页 >域名 >MySQL中的SQL Mode及其作用 正文

MySQL中的SQL Mode及其作用

来源:益强资讯优选   作者:系统运维   时间:2025-11-05 07:59:41
MySQL中的SQL Mode及其作用
复制root@database-one 22:48:  [(none)]> show variables likesql_mode;  +---------------+-------------------------------------------------------------------------------------------------------------------------------------------+ | Variable_name | Value                                                                                                                                     |  +---------------+-------------------------------------------------------------------------------------------------------------------------------------------+ | 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,NO_ENGINE_SUBSTITUTION |  +---------------+-------------------------------------------------------------------------------------------------------------------------------------------+ 1 row inset (0.05 sec)  root@database-one 22:48:  [(none)]> select @@sql_mode;  +-------------------------------------------------------------------------------------------------------------------------------------------+ | @@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,NO_ENGINE_SUBSTITUTION |  +-------------------------------------------------------------------------------------------------------------------------------------------+ 1 row inset (0.00 sec)  1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.

标签:

责任编辑:数据库