Using Int as Enum in MySQL

Hi SUJAYS,

An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time.

It is strongly recommended that you do not use numbers as enumeration values, because it does not save on storage over the appropriate TINYINT or SMALLINT type, and it is easy to mix up the strings and the underlying number values, if you quote the ENUM values incorrectly.

For more details on ENUM Type in MySQL please refer the below link.

https://dev.mysql.com/doc/refman/8.0/en/enum.html

Creating ENUM Columns

An enumeration value must be a quoted string literal.

CREATE TABLE Colors 
( 
    Name ENUM('Red', 'Blue', 'Green', 'Yellow')
);

Inserting and Selecting ENUM Columns

INSERT INTO Colors (Name) 
VALUES ('Green'),
       ('Red'),
       ('Yellow'),
       ('Blue');
SELECT Name FROM Colors

Screenshot