Hi,
My question about the mysql query -:
What is SERIAL data type in MySQL?
Thanks
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Nipun TomarPosted Jan 2, 2012, 11:57 PM
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 NayakPosted Jan 2, 2012, 12:27 PM
Please refer the below link
http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html
Thanks
Chintan RathodPosted Jan 2, 2012, 12:14 PM
SERIALis an alias forBIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE
SERIAL DEFAULT VALUEin the definition of an integer column is an alias forNOT NULL AUTO_INCREMENT UNIQUE.Thank you.