DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info) differences-from-ansi

Info Catalog (mysql.info) extensions-to-ansi (mysql.info) compatibility (mysql.info) constraints
 
 1.9.5 MySQL Differences from Standard SQL
 -----------------------------------------
 

Menu

 
* ansi-diff-subqueries         Subquery Support
* ansi-diff-select-into-table  `SELECT INTO TABLE'
* ansi-diff-transactions       Transactions and Atomic Operations
* ansi-diff-triggers           Stored Routines and Triggers
* ansi-diff-foreign-keys       Foreign Keys
* ansi-diff-views              Views
* ansi-diff-comments           '`--'' as the Start of a Comment
 
 We try to make MySQL Server follow the ANSI SQL standard and the ODBC
 SQL standard, but MySQL Server performs operations differently in some
 cases:
 
    * For `VARCHAR' columns, trailing spaces are removed when the value
      is stored. (This is fixed in MySQL 5.0.3). See  bugs.
 
    * In some cases, `CHAR' columns are silently converted to `VARCHAR'
      columns when you define a table or alter its structure. (This is
      fixed in MySQL 5.0.3). See  silent-column-changes.
 
    * There are several differences between the MySQL and standard SQL
      privilege systems. For example, in MySQL, privileges for a table
      are not automatically revoked when you delete a table. You must
      explicitly issue a `REVOKE' statement to revoke privileges for a
      table. For more information, see  revoke.
 
    * The `CAST()' function does not support cast to `REAL' or `BIGINT'.
      See  cast-functions.
 
    * Standard SQL requires that a `HAVING' clause in a `SELECT'
      statement be able to refer to columns in the `GROUP BY' clause.
      This cannot be done before MySQL 5.0.2.
 
Info Catalog (mysql.info) extensions-to-ansi (mysql.info) compatibility (mysql.info) constraints
automatically generated byinfo2html