GNU Info

(mysql.info)Differences from ANSI

---

Next: ANSI mode Prev: Extensions to ANSI Up: Compatibility

---

Enter node , (file) or (file)node

MySQL Differences Compared to ANSI SQL92
----------------------------------------

We try to make MySQL follow the ANSI SQL standard and the ODBC SQL
standard, but in some cases MySQL does some things differently:

   * `--' is only a comment if followed by a white space. Note: Missing
     comments.

   * For `VARCHAR' columns, trailing spaces are removed when the value
     is stored. Note: Bugs.

   * In some cases, `CHAR' columns are silently changed to `VARCHAR'
     columns. Note: Silent column 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. Note: `GRANT'.

   * `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.