Ok, so in the MySQL documentation section 7.3.4.3 it reads
"If you store a number into an ENUM, the number is treated as an index, and the value stored is the enumeration member with that index. (However, this will not work with LOAD DATA, which treats all input as strings.)"
Now my question is what happens when you want to store zero, "0" as one of your values. The index of 0 is reserved for NULL but 0 is a number. So what index will be assigned?
"If you store a number into an ENUM, the number is treated as an index, and the value stored is the enumeration member with that index. (However, this will not work with LOAD DATA, which treats all input as strings.)"
Now my question is what happens when you want to store zero, "0" as one of your values. The index of 0 is reserved for NULL but 0 is a number. So what index will be assigned?