Question

What is the correct usage of ENUM in MySQL?

a.`Create table size (ENUM ('Small','Medium','Large'));`
b.`Create table ENUM (name ('Small','Medium','Large'));`
c.`Create table size (name: ENUM['Small','Medium','Large']);`
d.`Create table size (name ENUM('Small','Medium','Large'));`

Answer 1

The correct usage of ENUM in MySQL is option d, where the ENUM type is used for a column named 'name' in a table called 'size', with the values 'Small', 'Medium', and 'Large'.

Step-by-step explanation:

The correct usage of ENUM in MySQL when creating a table with an enumeration of values is shown by option d: Create table size (name ENUM('Small','Medium','Large'));.

In this statement, size is the name of the table, and name is the column that will have the ENUM type. The ENUM values ('Small', 'Medium', 'Large') represent the allowed values for this column. It's important to define ENUM values within parentheses and separated by commas directly after the ENUM keyword.

The correct usage of ENUM in MySQL is option d.

Create table size (name ENUM('Small','Medium','Large'));

ENUM is a data type in MySQL that allows you to define a list of possible values. In this case, we are creating a table called 'size' with a column named 'name', which will store one of the values 'Small', 'Medium', or 'Large'.

Using the correct syntax is important to ensure that the table is created correctly and that the ENUM values are properly defined.