The rephrased title is: MySQL table name using double quotes

Question

I am executing a mysql query like this:

Select * from "User";

It returns:

There is an error in your SQL syntax; check the manual for your MySQL server version for the correct syntax to use near "User" on line 1

Error with double quotes", can I leave the select statement unchanged and let mysql handle the double quotes?

Answer 1

Excerpted from this article:

SET GLOBAL SQL_MODE=ANSI_QUOTES;

When I personally test, I must do this:

SET SQL_MODE=ANSI_QUOTES;

I think there is no other way.