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 Server遵循ANSI SQL标准和ODBC SQL标准,但MySQL Server在某些情况下执行的操作不同:
There are several differences between the MySQL and standard SQL privilege systems. MySQL和标准SQL特权系统之间有几个区别。For example, in MySQL, privileges for a table are not automatically revoked when you delete a table. 例如,在MySQL中,删除表时不会自动吊销表的权限。You must explicitly issue a 必须显式发出REVOKE
statement to revoke privileges for a table. REVOKE
语句才能吊销表的特权。For more information, see Section 13.7.1.8, “REVOKE Statement”.有关更多信息,请参阅第13.7.1.8节,“REVOKE语句”。
The CAST()
function does not support cast to REAL
or BIGINT
. See Section 12.11, “Cast Functions and Operators”.CAST()
函数不支持强制转换为REAL
或BIGINT
。参见第12.11节,“Cast函数和运算符”。