title: Inserting a row at a specific position?
body: <p>So I created a recipe database, and just now I've noticed I forgot to add an ingredient to the second recipe. The order of ingredients is obviously important here, so even if I add it now to the end of the table, it will still be the last when I <code>SELECT</code> the second recipe, when it should be the second ingredient.</p>
  
  <p>Is there any way I can insert it in a specific position, or am I doomed and will have to create an <code>index</code> column specifying the order of the ingredients?</p>
  
  <p>NOTE: This is a junction table, so there's no primary key here, thus I can't insert it using a specific primary key value.</p>
  
  <p><strong>EDIT:</strong> Basically I have three tables: <code>Recipe</code>, <code>Ingredient</code>, and <code>RecipeIngredient</code> many-to-many junction table.</p>
  
  <p>Here's the <code>RecipeIngredient</code> junction table structure:</p>
  
  <pre><code>RecipeId: FK
  IngredientId: FK
  Quantity: REAL
  UOM: TEXT
  Notes: TEXT
  </code></pre>