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
View Replies:
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.