Data type in mysql

Question

Hi My question about the mysql query -: What is SERIAL data type in MySQL? Thanks

James Tomar · Answer

Hi Arjun SERIAL data type is an alias for BIGINT UNSIGNED NOT NULLAUTO_INCREMENT UNIQUE. For detail description plz read: http://www.postgresql.org/docs/7.3/static/datatype.html#DATATYPE-SERIAL Thanks

Satyapriya Nayak · Answer

Hi Arjun Please refer the below link http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html Thanks

Chintan Rathod · Answer

Description: SERIAL is an alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE SERIAL DEFAULT VALUE in the definition of an integer column is an alias for NOT NULL AUTO_INCREMENT UNIQUE . Thank you.