If you choose to set the sql-mode
via sql-mode=ANSI, whether from the command line or in the configuration
file, be aware that this approach is neither recommended nor supported. It
disables a number of mysql extensions to the syntax of ANSI sql,
including the freedom to use double quotes in place of single quotes for
strings that have embedded single quotes, as with some of the database symbol
load scripts. Perhaps more critically, there are also reports of additional
restrictions on the use of sql reserved words as identifiers.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.