MySQL Variables sql_notes 数据库 参数变量解释及正确配置使用
本站中文解释
MySQL参数变量sql_notes可以用来控制是否在查询结果中显示额外的提示信息。它可以通过设置session system variable来指定被显示或者隐藏。若要设置MySQL参数变量sql_notes,需要使用下面命令:
SET GLOBAL sql_notes = 0; //隐藏额外的提示信息
SET GLOBAL sql_notes = 1; //显示额外的提示信息
官方英文解释
sql_notes
System Variable | sql_notes |
---|---|
Scope | Global, Session |
Dynamic | Yes |
Type | Boolean |
Default Value | ON |
If enabled (the default), diagnostics of
Note
level increment
warning_count
and the server records them.
If disabled, Note
diagnostics do not
increment warning_count
and
the server does not record them. mysqldump
includes output to disable this variable so that reloading the
dump file does not produce warnings for events that do not
affect the integrity of the reload operation.