Possible value for a ENUM column : ENUM « Data Types « MySQL Tutorial






  1. MySQL Tutorial
  2. Data Types
  3. ENUM

A column specified as ENUM('one', 'two', 'three') can have any of the values shown here

The index of each value is also shown:

ValueIndex
NULLNULL
''0
'one'1
'two'2
'three'3










10.10.ENUM
10.10.1.ENUM Type
10.10.2.Possible value for a ENUM column
10.10.3.ENUM with default value
10.10.4.Use ENUM type column
10.10.5.Inserting data to ENUM type column
10.10.6.Use numeric operation in ENUM type column
10.10.7.If you retrieve an ENUM value in a numeric context, the column value's index is returned