|
|
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
Navigation:
[Reply to this message]
|