Re: error 1064
groups is a reserved word to MySQL (Refer to
https://dev.mysql.com/doc/refman/8.4/en/keywords.html#keywords-8-4-detailed-G).
Do not use it as the name for anything (table, column, etc.) or as a Correlation Name (Table Alias) in your queries.
And yes, you
can get around it by using backticks around the offending name, but
don't. It will come back and bite you eventually.
Regards, Phill W.
Subject
Written By
Posted
Re: error 1064
July 31, 2024 08:44AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.