Check for yourself in the official docs at: http://dev.mysql.com/doc/refma

What is SERIAL data type in MySQL?

Question Posted / simon mahony

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

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 good database?

887

Can foreign key have duplicate values?

843

How to update a root password.

900

Can you shard mysql?

874

How do I make an action query?

863

How to Change a users password from unix shell.

1024

What does do in mysql?

823

What is blob and clob?

892

What are the benefits of mysql?

874

What is difference mysql and mysqli?

909

What are the different column comparison operators in mysql?

886

Can you tell what are various ways to create an index?

817

Explain the architecture models of SQL Server?

2285

What does mysql workbench do?

808

What is ndb in mysql?

903