What is SERIAL data type in MySQL?

Answer Posted / simon mahony

Check for yourself in the official docs at:
http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html

This states:
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.

Is This Answer Correct ?    16 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is mysql a server?

468


How do I create a mysql username and password?

496


Can we rollback truncate in mysql?

518


What is the maximum size of mysql database?

484


What is unsigned in mysql?

506






Can you tell the difference between ereg_replace() and eregi_replace()?

526


How do I restore a mysql database dump file in linux?

483


What is the difference between primary key and candidate key?

506


What is difference between oracle sql and mysql?

491


How many rows we can insert in a mysql table?

487


Can mongodb replace mysql?

525


Difference between CHAR and VARCHAR?

585


What is blob storage?

494


What is the difference between float and double?

587


how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.

513