What is SERIAL data type in MySQL?

Question Posted / amith

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

Answers were Sorted based on User's Feedback

What is SERIAL data type in MySQL?..

Answer / 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

What is SERIAL data type in MySQL?..

Answer / 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

What is SERIAL data type in MySQL?..

Answer / amith

BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT .

Is This Answer Correct ?

44 Yes

32 No

Post New Answer