Reserved Words and UTF8MB4 Issues The upgrade checker utility in
the new MySQL Sell will warn you about potential problems.
The two most common problems I have seen are finding out one of
your column names is a reserved word and character sets.
Reserved Words
You will spot reserved word issues on the second step of the
upgrade check: 2) Usage of db objects with names conflicting with
reserved keywords in 8.0 Warning: The following objects
have names that conflict with reserved keywords
that are new to 8.0. Ensure queries sent by your applications use
`quotes` when referring to them or they will result
in errors. More information:
https://dev.mysql.com/doc/refman/en/keywords.html
davetest.reserved_word.over - Column name
In the above we are being told that in the schema 'davetest' in
the table 'reserved_word' that there is a column named 'over'
that …
Showing entries 1 to 1
Sep
25
2019
Showing entries 1 to 1