Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://mariadb.com/docs/release-notes/compatibility-and-differences/sql_modemssql below:

SQL_MODE=MSSQL | MariaDB Documentation

1. Compatibility & Differences

SET SQL_MODE=MSSQL implies all the following sql_mode flags:

Setting the sql_mode 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 identifiers:

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
)

You can use '[' in identifiers. If you want to use ']' in identifiers you have to specify it twice.

_{This page is licensed: CC BY-SA / Gnu FDL}

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4