Why my MySQL query doesn't show syntax error when it has redundant dot character

Question

When i run this query on my local mysql server, it can run OK

SELECT. 
  im.item_no
FROM
  item_master im;

But on my live server it cause a syntax error

SELECT. im.item_no FROM item_master im 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '. im.item_no FROM item_master im' at line 1 Time: 0.235s

I know the query has invalid dot character after SELECT, but i want to know why it doesn't show the error on my local server. Do i missing any config here ? I want to show the error message on local server so that i can easily debug another query.

========

Update image that the invalid query still work OK on my local server

Worked query

Worked query on CLI

========

@Akina and @P.Salmon help me to figure out the reason is MySQL version different between local and live server

Version 5.x can run this query but version 8.0 is NOT

We still looking for the solution the let version 5.x to display the syntax error like 8.0 version

Answer 1

等待大神答复