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

How do I run mysql on a mac?

479


Why do we write stored procedures?

481


How to calculate the difference between two time values?

459


What does it mean to be case sensitive?

476


What is a select query?

479






What is use of mysql?

495


How to control the max size of a heap table?

553


1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?

1555


How to use mysqldump to create a copy of the database?

506


Is mysql free download?

480


How to analyze tables with 'mysqlcheck'?

713


What is the query to display top 20 rows?

611


How do I find my mysql username and password?

551


How can I remotely connect to mysql database?

452


What is the maximum size of table in mysql?

561