Posted by Rik on 01/21/07 00:42

Simon wrote:
> Hello!
>
> Is there anything in MySQL taht allows user to store in one filed
> multiple values?
> I mean something like SET; but we cannot store in set nothing except
> for values declared while TABLE creation, and I need some kind of
> equivalent for list.

You can add / remove / alter the SET by the ALTER syntax.
If that's not what you want, I'd go for an extra table.

table_main
id
name

table_values
id
name

table_main_values
table_main_id
table_values_id
--
Rik Wasmus

[Back to original message]