The difference between "and" in MySQL

The two are different under Linux and under Windows, under Linux is not differentiated under Windows.

The main difference under Windows is

Single quotation marks (') or double quotation marks are used primarily for string reference symbols

Such as:

mysql> Select ' Hello ', ' "Hello" ', ' "" Hello "" ', ' Hel ' lo ', '/' hello ';

Database, table, index, column, and Alias are quoted as a counter-tick ("') Note: The key below ESC

Such as:

Mysql>SELECT * from ' SELECT ' WHERE ' select '. ID >;

If the SQL Server mode includes the ansi_quotes mode option, you can also enclose the identifier in double quotation marks:

CREATE TABLE "Test" (Col INT);

ERROR 1064:you has an error in your SQL syntax. (...)

SET sql_mode= ' ansi_quotes ';

CREATE TABLE "Test" (Col INT);

Query OK, 0 rows Affected (0.00 sec)

The difference between "and" in MySQL