title: How to record sequential collections of records in MySQL
body: <p>Suppose I have a table that holds some type of record, say cooking instructions like <code>"Fold the melted chocolate into the egg whites"</code>.  The table contains a unique ID field and the string.</p>
  
  <p>I want to build another table for recipes (each with a unique ID and a name), each of which would be a series of sequential instructions (some instructions would be used for several/many recipes).</p>
  
  <p>What is the best way to structure my recipe table to map a recipe's unique ID to a <strong>sequential</strong> series of instructions (which IDs are not sequential)?</p>