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:
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
REVOKEstatement to revoke privileges for a table. For more information, see Section 126.96.36.199, “REVOKE Statement”.
CAST()function does not support cast to
BIGINT. See Section 12.11, “Cast Functions and Operators”.