Skip navigation links
MySQL Restrictions and Limitations :: 10 MySQL Differences from Standard SQL
10.1 SELECT INTO TABLE »
Section Navigation      [Toggle]

Chapter 10. MySQL Differences from Standard SQL

Table of Contents     [+/-]

10.1. SELECT INTO TABLE
10.2. UPDATE
10.3. Transactions and Atomic Operations
10.4. Foreign Keys
10.5. '--' 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 Syntax.

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

Copyright © 1997, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices