What is SERIAL data type in MySQL?
Answers were Sorted based on User's Feedback
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 |
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 |
How do you select a table?
Why myisam is faster than innodb?
Why do we use mysql?
What are Heap tables?
How do I connect to a database in mysql workbench?
Which statement is used to delete a table in MySQL.
What is query log in mysql?
What is cast in mysql?
what are the different tables present in mysql? : Mysql dba
In the below example, how many String Objects are created? String s1="I am Java Expert"; String s2="I am C Expert"; String s3="I am Java Expert";
What is mysql routine?
What is the difference between char and varchar?