About ENUM

[danielbala]

Hi all...........

I shud just how to use ENUM type in mysql..like shud i give any field in form in a website and how to assign a values for eg 0 for admin,1 for manager and 2 for the staff using phpmyadmin??

please help me.................

[smantscheff]

Use an enum field with literal values. Define it as
myField enum('admin','manager','staff')
instead of numerical values.