Case

SQLEnumSyntax.inline

MySQL’s “inline” enumerations.

case inline

Discussion

MySQL defines an ENUM field type, which contains a listing of its individual cases inline. The cases can be changed after the initial defintion via ALTER TABLE.

MySQL example:

CREATE TABLE `foo` (
    `id` BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    `my_fruit` ENUM ('apple', 'orange', 'banana') NOT NULL
);