MySQL :: MySQL 8.4 Reference Manual :: 1.7.2 MySQL Differences from Standard SQL

version 8.4

8.0 current
5.7

8.0 Japanese

MySQL 8.4 Reference Manual / ... / 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:

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 15.7.1.8, “REVOKE Statement”.
The CAST() function does not support cast to REAL or BIGINT. See Section 14.10, “Cast Functions and Operators”.

PREV HOME UP NEXT