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 |
What is mysql optimization?
How do I delete a row in mysql?
Explain Normalization concept?
What are the applications required to support mysql?
What is the use of mysql workbench?
What is username in mysql?
What is ntext?
how to take mysql database structure backup
What is mysql good for?
How can you change the name of any existing table by using the sql statement?
How to use in conditions?
Can mysql handle big data?
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)