SQL standard to escape column names?

Question

Is there a SQL standard to escape a column name? If not what works for mysql and sqlite? does it also work for sqlserver?

Answer 1

For MySQL, use ticks `.

For instance:

SELECT `column`, `column2`, FROM `table`

Answer 2

For MS SQL use [ and ]

SELECT [COLUMN], [COLUMN 2] FROM [TABLE]

Answer 3

The SQL-99 standard specifies that double quote (") is used to delimit identifiers.

Oracle, PostgreSQL, MySQL, MSSQL and SQlite all support " as the identifier delimiter (though they don't all use " as the 'default' - for example, you have to be running MySQL in ANSI mode and SQL Server only supports it when QUOTED_IDENTIFIER is ON.)

Answer 4

According to SQLite,

• 'foo' is an SQL string
• "foo" is an SQL identifier (column/table/etc)
• [foo] is an identifier in MS SQL
• `foo` is an identifier in MySQL

I'm not sure if MS SQL and MySQL support the standard "foo".