MySQL's anti-quote Backtick

In MySQL query statements, when identifiers contain special characters or reserved words, these identifiers need to be enclosed in ('), for example, when querying a data table named Foo#bar, or a field called SELECT, you should write these two identifiers as ' and FOO#BAR` 'SELECT`,因为反引号提供一个额外的安全保护,它在程序生成的sql语句中被广泛运用.

Many other database systems use double quotes ( " ) to enclose special symbols, and to improve portability, you can add Sql_mode values so that you ANSI_QUOTES can enclose special symbols in double quotes.

MySQL's anti-quote Backtick