Forums

MySQL8 reserved keywords

Permalink
My client's host has just upgraded to MySQL8 and, of course, we now have a 1064 error around the word 'groups'. I've read some stuff online about reserved keywords and adding backticks, but I can't find anything in the forums about which files need to be changed.

Are there any C5 devs out there who could give me a comprehensive guide? Pretty please?

Version is 5.6, hence using the legacy forum.
WebOnTheWebb
 
Cardona787 replied on at Permalink Reply
In MySQL, certain words like SELECT, INSERT, DELETE etc. are reserved words. Since they have a special meaning, MySQL treats it as a syntax error whenever you use them as a table name, column name, or other kind of identifier - unless you surround the identifier with backticks.

This website stores cookies on your computer. These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media. To find out more about the cookies we use, see our Privacy Policy.