1.8.2 MySQL Differences from Standard SQL

1.8.2.1 SELECT INTO TABLE Differences
1.8.2.2 UPDATE Differences
1.8.2.3 Transaction and Atomic Operation Differences
1.8.2.4 Foreign Key Differences
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: