View Poll Results: ENUM type columns, or Normal Columns with a Lookup table for a set # of values?
- 2. You may not vote on this poll
ENUM Type Column with a function or script to extract the values into a SELECT menu in a form
A normal column with all the values stored separately, with a lookup table column in a different table.
Jul 18, 2001, 21:04 #1
- Join Date
- May 2001
- 0 Post(s)
- 0 Thread(s)
Poll: ENUM Type columns or a normal column and a lookup table?
I wanted to get some of your opinions...is it better to store a set number of values (less than 64 000) in an ENUM type column and extract the values into a webpage form using some function or script, or to store all the values separately in a column, and then have a lookup table for the values? Any and all responses are welcome and appreciated!!