1.8.4 MySQL Differences Compared To SQL-92

We try to make MySQL Server follow the ANSI SQL standard (SQL-92/SQL-99) and the ODBC SQL standard, but in some cases MySQL Server does things differently:

• For VARCHAR columns, trailing spaces are removed when the value is stored. See section 1.8.6 Known Errors and Design Deficiencies in MySQL.
• In some cases, CHAR columns are silently changed to VARCHAR columns. See section 6.5.3.1 Silent Column Specification Changes.
• Privileges for a table are not automatically revoked when you delete a table. You must explicitly issue a REVOKE to revoke privileges for a table. See section 4.3.1 GRANT and REVOKE Syntax.
• NULL AND FALSE will evaluate to NULL and not to FALSE. This is because we don't think it's good to have to evaluate a lot of extra conditions in this case.

For a prioritised list indicating when new extensions will be added to MySQL Server, you should consult the online MySQL TODO list at http://www.mysql.com/doc/en/TODO.html. That is the latest version of the TODO list in this manual. See section 1.9 MySQL and The Future (The TODO).

Subsections

• 1.8.4.1 Subqueries
• 1.8.4.2 SELECT INTO TABLE
• 1.8.4.3 Transactions and Atomic Operations
• 1.8.4.4 Stored Procedures and Triggers
• 1.8.4.5 Foreign Keys
• 1.8.4.6 Views
• 1.8.4.7 `--' as the Start of a Comment

User Comments

Add your own comment.