sql-info.de
September 23, 2004

MySQL | SERIAL

While browsing the online documentation I came across this snippet:

From MySQL 4.1.0, the attribute SERIAL can be used as an alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE. This is compatibility feature.

(See: http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html)

The question is of course: for what is this compatibility feature exactly intended? Could it possibly be for PostgreSQL's - non-standard - SERIAL type?

(This wouldn't be the first PostgreSQL compatibility feature, the SELECT clause LIMIT ... OFFSET exists for "compatibility with PostgreSQL": http://dev.mysql.com/doc/mysql/en/SELECT.html )

Posted at 8:06 PM