SET SQL_MODE=MSSQL implies all the following flags:
Setting the system variable to MSSQL allows the server to understand a small subset of Microsoft SQL Server's language. For the moment MSSQL mode only has limited functionality, but we plan to add more later according to demand.
One can use [] instead of "" or `` for quoting :
You can use '[' in identifiers. If you want to use ']' in identifiers you have to specify it twice.
SET SQL_MODE="MSSQL";
CREATE TABLE [t 1] ([a b] INT);
SHOW CREATE TABLE [t 1];
Table Create Table
t 1 CREATE TABLE "t 1" (
"a b" INT(11) DEFAULT NULL
)This page is licensed: CC BY-SA / Gnu FDL