What is the difference between SERIAL and AUTO_INCREMENT in mysql

As per the docs

SERIAL is an alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE.

So, be careful when creating a reference to a SERIAL PK, since that reference column has to be of this exact type.