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.
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.
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.
