MySQL Forums :: Newbie :: Store multiple and not-predefined values in one column


Advanced Search

Store multiple and not-predefined values in one column
Posted by: Camilo Rivera ()
Date: February 22, 2009 08:39PM

Hi,

I need to store various values in one column:

id | myValues |
---+---------------+
1 | 'a', 'c', '7' |
2 | 'hello', 'yes'|
---+---------------+

Each value is based on user-generated data. So, the list of possible values for SET or ENUM should be updated everytime a user adds a new option.

Is there a way for Storing multiple and not-predefined values in one column?

This has been holding me for a long time.

Thanks in advance.



Edited 4 time(s). Last edit at 02/22/2009 09:53PM by Camilo Rivera.

Options: ReplyQuote


Subject Written By Posted
Store multiple and not-predefined values in one column Camilo Rivera 02/22/2009 08:39PM
Re: Store multiple and not-predefined values in one column Jay Alverson 02/23/2009 09:00AM
Re: Store multiple and not-predefined values in one column Camilo Rivera 02/23/2009 10:59AM
Re: Store multiple and not-predefined values in one column Rick James 02/23/2009 09:53AM
Re: Store multiple and not-predefined values in one column Camilo Rivera 02/23/2009 10:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.