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 |
Should I use pdo or mysqli?
What does it mean to be case sensitive?
Is mariadb faster than mysql?
How do you determine the location of mysql data directory?
How to delete a database from mysql server.
What is the difference between the LIKE and REGEXP operators?
How do I start mysql database?
What is ntext?
What is the difference between truncate and delete?
How to create a new view in mysql?
What is text in mysql?
what programming language which is used for testing and developement in sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)