How many values is possible in enum datatype of mysql?

How many values could be used in enum datatype in mysql ? I meant like emum('yes','no') ,here yes,no are values ,how many of these could be possible wit开发者_JAVA百科h enum

A quick lookup shows it's a max of 65535 elements. See the MySQL documentation.

http://dev.mysql.com/doc/refman/5.1/en/enum.html

An enumeration can have a maximum of 65,535 elements.

as of MySQL 5.0 - 5.6

According to this doc,

An enumeration can have a maximum of 65,535 elements.

An enumeration can have a maximum of 65,535 elements.

Source: http://dev.mysql.com/doc/refman/5.0/en/enum.html

An enumeration can have a maximum of 65,535 elements.

REFERENCE