Reserved Keywords in a MySQL 5.7 to 8 Upgrade

MySQL Server 5.7 will reach end of life (EOL) in October 2023, so if you haven’t done that yet, upgrade your SQL database instances to MySQL 8 now – please perform a MySQL 5.7 to 8 upgrade, aned this video will explain how best to do it to avoid mishaps related to reserved keywords.

The first thing you should note is that MySQL Server 8.0 introduced a bunch of reserved keywords that will make your mysql server throw a syntax error if you try to perform an upgrade.
To avoid such an issue, make sure to wrap all table and column names in backticks. Bear in mind that doing so over the long run is not advisable as doing so only masks the problem – after doing that, go ahead and change the names bearing reserved keywords to something else instead, and your mysql 8.0 installation should be good to go.

A list of reserved keywords in MySQL 8 can be found here (link valid for 1 year): https://pastebin.com/TMvn2J20
Examine those keywords, avoid using them, and until next time!

Also make sure to watch other videos on our channel to know your way around sql interview questions and answers, to know sql for beginners, what sql injection is, know a thing or two about sql vs nosql, sql queries and sql basics for your next sql project. Enjoy the video!

Music:
Evening by Qlowdy https://soundcloud.com/qlowdymusic
Creative Commons — Attribution 3.0 Unported — CC BY 3.0
Free Download / Stream: https://bit.ly/3NNExs1
Music promoted by Audio Library: https://www.youtube.com/watch?v=RXx3SO4PVDI

#database #mysql #sql #web #webdevelopment #developer #webdeveloper