How do I store a list in a column in MySQL? I mean, what kind of MySQL variable should I use?
I have a table in a MySQL database where I store some information about a product (size, code, etc.). One such information is the purchase notes for this product. Once the product is replenished in stock, there will be several notes for the same product, which I will need to list later. I have a table of "Notes" and one of "Product".
I would like in the "Notes" column of the "Product" table I could save a list of IDs from the "Notes" table.