(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