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

What is unique key in mysql?

692


What is a deterministic function?

799


What is datadir?

634


How do I assign a variable in mysql?

668


1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?

2157


What are the functions of mysql?

659


What is relational database in mysql?

677


How do I run mysql from command line?

703


What you can use regular expression for in mysql? Support your answer with an example?

637


How do I start mysql server?

647


What are ddl statements in mysql?

720


What is limit in mysql?

638


Is mysql a database?

672


How do you create a table in mysql workbench?

644


How to use regular expression in pattern match conditions?

719