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
Post a Comment