1.8.2 MySQL Differences from Standard SQL

1.8.2.1 SELECT INTO TABLE
1.8.2.2 UPDATE
1.8.2.3 Transactions and Atomic Operations
1.8.2.4 Foreign Keys
1.8.2.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: