Showing entries 1 to 1
Displaying posts with tag: reserved words (reset)
Upgrading from MySQL 5.7 to MySQL 8.0 Part II

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 …

[Read more]
Showing entries 1 to 1