Re: error 1064

[Phillip Ward]

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.