PostgreSQL vs MySQL: 7 syntax differences that break migrations

Porting a working MySQL schema to PostgreSQL is rarely a find-and-replace. The SQL standard leaves...