mysql - how can I store a set of values in SQL table -


I need to store a set of values ​​A, B, C is called the country column of a SQL table . Would you please tell me if there is a data type that is able to store a set of values ​​in the SQL table column?

Thanks in advance.

To store a set, you usually create a second table with a foreign key relationship Are there.

Comma in a column in MySQL, the Separator list, as if it is considered bad form, though you can choose it for a quick hack of one time.

EDIT: For some reason, Bakkal removed his answer, the answer was new to me and I thought it was interesting, so I will copy it here:

< / P>

This gives you a small set (at least 65 items) in one column.


Comments