Answer
Using Enum can restrict the number of values that can be allowed to go inside a table. If there is an ENUM for Colors ENUM(‘blue’,’yellow’,’green’) I can use an insert statement like Insert colors values (‘red’).

NEXT>>

More MySQL Links

What are the Performance and Scalability characteristics of MySQL?

Answer - MySQL has a unique storage engine architecture that makes it adaptable to most.........
Explain the difference between BOOL, TINYINT and BIT.

Answer - BIT data type can store up to 8 bytes from My SQL version 5.0.3.......

Describe Transaction-Safe Table Types in MySQL

Answer - While using transactions in MySQL a transaction –safe table type must.......
Describe MySQL Connection using PHP Script.

Answer - Establishing connection to MySQL database using PHP can be done...........

Today's Hot Jobs

C++ SQL Server

.NET Java Oracle

Finance Marketing

Seekers Employers

MySQL ENUMs

NEXT>>

What are ENUMs used for in MySQL?

NEXT>>

What are the Performance and Scalability characteristics of MySQL?

Explain the difference between BOOL, TINYINT and BIT.

Describe Transaction-Safe Table Types in MySQL

Describe MySQL Connection using PHP Script.