title: How would i store unknown amount of data in mysql table?
body: <p>I have online store that has simple products ( 1 product has 1 price and 1 color and 1 field for bought count ).
  How i want to extend that is to have ( 1 product has X price's and X colors and bought count for each of colors seperated ).
  So the regular approach to have specific count of fields for all values doesn't work here.</p>
  
  <p>So my question: How would i store unknown count of prices and colors for 1 product and also bought count for each type of that product?</p>
  
  <p>Do i serialize data from php and store it in BLOB field type? What would be suggested or industry standart way of doing this sort of thing?</p>
  
  <p>Thanks.</p>