case-sensitive in MySQL Server on operating systems that have case-sensitive file names (such as most Unix systems). See Section 9.2.3, “Identifier Case Sensitivity” . 

•General language syntax 

•By default, strings can be enclosed by "  as well as ’ . If the ANSI_QUOTES  SQL mode is enabled, strings can be enclosed only by ’  and the server interprets strings enclosed by "  as identifiers. 

• \  is the escape character in strings. 

•In SQL statements, you can access tables from different databases with the db_name.tbl_name syntax. Some SQL servers provide the same functionality but call this User space . MySQL Server doesn’t support tablespaces such as used in statements like this: CREATE TABLE ralph.my_table ... IN my_tablespace . 

•SQL statement syntax 

•The ANALYZE TABLE , CHECK TABLE , OPTIMIZE TABLE , and REPAIR TABLE  statements. 

•The CREATE DATABASE , DROP DATABASE , and ALTER DATABASE  statements. See Section 13.1.12, “CREATE DATABASE Statement” , Section 13.1.24, “DROP DATABASE Statement” , and Section 13.1.2, “ALTER DATABASE Statement” . 

•The DO  statement. 

• EXPLAIN SELECT  to obtain a description of how tables are processed by the query optimizer. 

•The FLUSH  and RESET  statements. 

•The SET  statement. See Section 13.7.6.1, “SET Syntax for Variable Assignment” . 

•The SHOW  statement. See Section 13.7.7, “SHOW Statements” . The information produced by many of the MySQL-specific SHOW  statements can be obtained in more standard fashion by using SELECT  to query INFORMATION_SCHEMA . See Chapter 26, INFORMATION_SCHEMA Tables . 

• Use of LOAD DATA . In many cases, this syntax is compatible with Oracle LOAD DATA . See Section 13.2.7, “LOAD DATA Statement” . 

•Use of RENAME TABLE . See Section 13.1.36, “RENAME TABLE Statement” . 

•Use of REPLACE  instead of DELETE  plus INSERT . See Section 13.2.9, “REPLACE Statement” . 

•Use of CHANGE col_name , DROP col_name , or DROP INDEX , IGNORE  or RENAME  in ALTER TABLE statements. Use of multiple ADD , ALTER , DROP , or CHANGE  clauses in an ALTER TABLE  statement. See Section 13.1.9, “ALTER TABLE Statement” . 

•Use of index names, indexes on a prefix of a column, and use of INDEX  or KEY  in CREATE TABLE statements. See Section 13.1.20, “CREATE TABLE Statement” . 

•Use of TEMPORARY  or IF NOT EXISTS  with CREATE TABLE . 

•Use of IF EXISTS  with DROP TABLE  and DROP DATABASE . 

•The capability of dropping multiple tables with a single DROP TABLE  statement. 

•The ORDER BY  and LIMIT  clauses of the UPDATE  and DELETE  statements. 

• INSERT INTO tbl_name  SET col_name  = ...  syntax. 

