(mysql.info.gz) Differences from ANSI

(mysql.info.gz) Extensions to ANSI

 
 1.5.5 MySQL Differences from Standard SQL
 -----------------------------------------
 
 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. (Fixed in MySQL 5.0.3).  Bugs.
 
    * In some cases, `CHAR' columns are silently converted to `VARCHAR'
      columns when you define a table or alter its structure. (Fixed in
      MySQL 5.0.3).   Silent column changes.
 
    * 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.  `GRANT' GRANT.
 
    * The `CAST()' function does not support cast to `REAL' or `BIGINT'.
       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.

 
* ANSI diff Subqueries        Subqueries
* ANSI diff SELECT INTO TABLE  `SELECT INTO TABLE'
* ANSI diff Transactions      Transactions and Atomic Operations
* ANSI diff Triggers          Stored Procedures and Triggers
* ANSI diff Foreign Keys      Foreign Keys
* ANSI diff Views             Views
* ANSI diff comments          `--' as the Start of a Comment

Info Catalog

(mysql.info.gz) Extensions to ANSI

(mysql.info.gz) Compatibility

(mysql.info.gz) Constraints

automatically generated byinfo2html

(mysql.info.gz) Differences from ANSI

Menu