MySQL Extensions to Standard SQL 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. 78