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:
In some cases,
are silently converted to
VARCHAR columns when you
define a table or alter its structure. See
Section 18.104.22.168, “Silent Column Specification 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
Section 22.214.171.124, “REVOKE Syntax”.