MySQL 8.4 Release Notes
我们尝试使 MySQL Server 遵循 ANSI SQL 标准和 ODBC SQL 标准，但 MySQL Server 在某些情况下执行操作的方式有所不同：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:
MySQL 和标准 SQL 权限系统之间存在一些差异。例如，在 MySQL 中，当您删除表时，表的权限不会自动撤销。您必须显式发出
REVOKE语句来撤销表的权限。有关详细信息，请参阅第 15.7.1.8 节“REVOKE 语句”。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 aREVOKEstatement to revoke privileges for a table. For more information, see Section 15.7.1.8, “REVOKE Statement”.CAST()函数不支持转换为REAL或BIGINT。请参阅第 14.10 节“转换函数和运算符”。TheCAST()function does not support cast toREALorBIGINT. See Section 14.10, “Cast Functions and Operators”.