Please review, whether I have used and understood enum or set correctly. Okay, what I have understood about enum and set in MySQL. For example, I have a table of continents, and a table of countries. The 3rd table is the tblSummary.
tblContinent
continent_ID
continentName
tblCountry
country_ID
countryName
Normally, I might just do this:
tblSummary
summary_ID
country_ID
continent_ID
But my question: is it correct if I set the country_ID and continent_ID as enum or set in the tblSummary ?
tblSummary
summary_ID
'country_ID'
'continent_ID'
I am refering to what phpmyadmin gave infos:
Do the infos in phpmyadmin mean like the example given above ?1 If field type is "enum" or "set", please enter the values using this format: 'a','b','c'...
If you ever need to put a backslash ("\") or a single quote ("'") amongst those values, precede it with a backslash (for example '\\xyz' or 'a\'b').
2 For default values, please enter just a single value, without backslash escaping or quotes, using this format: a
Thanks,
Chris