Topic awaiting preservation: mysql: enum, set difference

can anyone shortly describe what the main difference of the enum and the set type is?

and which one should i use for the category of different products. (toy, book, dvd, ...).
thanks.

neither. You should probably use a foreign key and another table.


In short, sets can have multiple members, while an enum can have only one.
Both are stored as strings.

for further info, see the manual

so long,

->Tyberius Prime

ok, thanks.

but why should i use another table and not an ENUM?

Using another table is a much more flexible solution. For example if you add a category you don't need to change the table definition.



.:[ Never resist a perfect moment ]:.

no, but i would have to insert another entry in the category table, which is about the same.

and an extra tablewould take extra memory and computing time, right?