mysql 表名引号,mysql双引号表名

I'm doing a mysql query like:

Select * from "User";

and it returns:

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 '"User"' at line 1

The error has something to do with the double-quotes ", can I keep the select statement as is, and make mysql cope with the double quotes?

解决方案

Taken from this post:

SET GLOBAL SQL_MODE=ANSI_QUOTES;

Personally when I tested, I had to do it like this:

SET SQL_MODE=ANSI_QUOTES;

I don't think there's any other way.

ANSI_QUOTES

Treat “"” as an identifier quote character (like the “`” quote

character) and not as a string quote character. You can still use “`”

to quote identifiers with this mode enabled. With ANSI_QUOTES enabled,

you cannot use double quotation marks to quote literal strings,

because it is interpreted as an identifier.