What are ENUMs used for in MySQL?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What are ENUMs used for in MySQL?

You can limit the possible values that go into the table. CREATE TABLE months (month ENUM ‘January’, ‘February’, ‘March’,…); INSERT months VALUES (’April’);

(Continued on next question...)

Other Job Interview Questions

• Explain the difference between FLOAT, DOUBLE and REAL.
• MySQL - Estimating Query Performance
• Explain the difference between FLOAT, DOUBLE and REAL.
• What is DDL, DML and DCL?
• How MySQL Stores Its Row Data and Index Data?
• MySQL - Replication Implementation Overview
• How MySQL Optimizes WHERE Clauses
• What does tee command do in MySQL?
• Explain federated tables.
• Explain the difference between BOOL, TINYINT and BIT.
• More...