1.

What is the use of enum in MySQL? How it is different from set?

Answer»

In MySQL, an ENUM is actually a string object whose value is selected from the list of permitted values pre-defined during the TIME of a column creation. It is USED because it provides compact data storage in ADDITION to readable queries and output.

Here’s the DIFFERENCE between an ENUM and a SET

ENUMSET
The value should be one listed in the column definition or INTERNAL numeric equivalent.Must be an empty string consisting of values listed in column


Discussion

No Comment Found

Related InterviewSolutions