title: How to store complex product/order data in MySQL?
body: <p>I'm working on an order system for my online shop. I have 2 tables:</p>
  
  <ol>
  <li>products, storing info about products</li>
  <li>orders, storing general id's &amp; infos of customer orders.</li>
  </ol>
  
  <p>Now I want to have a way to store complex customer orders in the database. I need something that will let me know how much of each size (S, M or L) of each product is in an order.</p>
  
  <p>The tricky part is that I want to be able to add/edit/delete products (of course without affecting orders from the past), so the method should be flexible</p>
  
  <p>How should I go about this?</p>
  
  <ol>
  <li>a separate table for every order, with products as rows? </li>
  <li>one table for all orders, with products as columns?</li>
  <li>some other option?</li>
  </ol>
  
  <p>Thanks!</p>