[+/-]
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:
For VARCHAR
columns, trailing
spaces are removed when the value is stored. See
Section A.5.8, “Known Issues in MySQL”.
In some cases, CHAR
columns
are silently converted to
VARCHAR
columns when you
define a table or alter its structure. See
Section 12.1.5.1, “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 12.4.1.3, “REVOKE
Syntax”.
The CAST()
function does not
support cast to REAL
or
BIGINT
. See
Section 11.9, “Cast Functions and Operators”.
User Comments
Add your own comment.