SERIAL is an alias for BIGINT UNSIGNED NOT NULL AUTO

What is SERIAL data type in MySQL?

Question Posted / bhavin parikh

3 Answers
48359 Views
Aspire, I also Faced
E-Mail Answers

Answer Posted / bhavin parikh

SERIAL is an alias for BIGINT UNSIGNED NOT NULL
AUTO_INCREMENT UNIQUE.
Reference Link :
http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html

Is This Answer Correct ?

79 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the command line end user interface - mysql?

1153

How to get data from mysql in php?

949

What is the usage of regular expressions in mysql?

943

What are the differences between char and varchar?

1152

What does innodb stand for?

1025

What is bigint in mysql?

974

What is the purpose of mysql database?

970

Can we store videos in mysql database?

1001

what is the difference between gui testing and database testing? : Mysql dba

1163

What are the non-standard sql commands supported by 'mysql'?

1048

How can you import tables from a sql file into a database by using the mysql client?

1091

What is cursor in mysql?

946

How to set mysql variable in php?

973

What is 1nf 2nf 3nf?

1034

How can we change the data type of a column of a table?

1049