(mysql.info.gz) Differences from ANSI
Info Catalog
(mysql.info.gz) Extensions to ANSI
(mysql.info.gz) Compatibility
(mysql.info.gz) Constraints
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.
Menu
* 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