Chapter 13 MySQL Differences from Standard SQL

Table of Contents

13.1 SELECT INTO TABLE Differences

13.2 UPDATE Differences

13.3 FOREIGN KEY Constraint Differences

13.4 '--' as the Start of a Comment

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 REVOKE Statement.

• The CAST() function does not support cast to REAL or BIGINT. See Cast Functions and Operators.