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
46261 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 sql similar to mysql?

483

Can we rename database in mysql?

491

What is blob in mysql?

501

How do you shutdown a mysql database?

505

What is the limitation of mysql?

482

Is mysql a odbc?

475

Can we store images in mysql database?

484

Is mysql a relational database?

442

How can we optimize stored procedure?

495

What is the default password for mysql?

467

How to show all tables with 'mysql'?

530

Explain Access Control Lists.

543

How you will Show unique records.

548

Is mysql workbench a dbms?

534

Is mariadb better than mysql?

553