Use of SET (and ENUM) MySQL data types

[Keith_Wilkinson]

I'm just after an example of how to use the SET and ENUM
data types with forms. As an example of such a form:

---

I am primarily a:
(o) Editor (o) Writer (o) Translator
specializing in
() General () Finance/economy () Medical () Patents/law

---

where (o) is a radio button and (*) is a checkbox.

This (the above) data entry form would
(1) Store selected check boxes as MySQL SET and
ENUM (bit) data (corresponding to check boxes
and radio buttons),
(2) In "Modify data entry form", mode display previously-
entered data (from database) as check box/radio button
form defaults,
(3) When SEND is clicked on form, display text labels of
checked checkboxes/radio buttons as confirmation
of data that has been sent.

Actually just (1) and (2) would be sufficient for
my purposes.

[steadyguy]

CREATE TABLE details
(
id MEDIUMINT(5) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
job ENUM('editor', 'writer', 'translator) NULL ,
area SET('general, 'economy', 'medical, 'law') NULL
);