Mysql prefix table name

[Anointedone]

Hi,

Ref: MySql v8.

I am using an application which has a table name called "system".
All other tables can be accessed by their name. However, only "system" can mandatory be accessed via prefix: dbname.system.

Therefore, the app fails. What is the cause and ultimate remedy?

Thank you!

 

[spamjim]

SYSTEM was added as a reserved word in MySQL 8.

https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-8-0-detailed-S

Wrap `system` in backticks (`) in your queries.