Hi!
I'd like users of my web form to choose between 6 different sites in a listbox.
The id of the selected site will be inserted into another table (Datasets).
MySQL structure:
Table: Sites
Field: Site_Id
Field: Site_Name (six alternatives)
....etc
Table: Datasets
Field: Dataset_Id
Field: Site_Id
....etc
Do I benefit from using the ENUM type for field Site_Name? Does ENUM in general take up less memory space than CHAR? I don't need ENUM to limit the entries to six alternatives, but how about effiency aspects?
I keep coming back to this question, so It would be nice to get it sorted out.
Thanks,
Maria
I'd like users of my web form to choose between 6 different sites in a listbox.
The id of the selected site will be inserted into another table (Datasets).
MySQL structure:
Table: Sites
Field: Site_Id
Field: Site_Name (six alternatives)
....etc
Table: Datasets
Field: Dataset_Id
Field: Site_Id
....etc
Do I benefit from using the ENUM type for field Site_Name? Does ENUM in general take up less memory space than CHAR? I don't need ENUM to limit the entries to six alternatives, but how about effiency aspects?
I keep coming back to this question, so It would be nice to get it sorted out.
Thanks,
Maria