title: ORDER BY id or date_created to show latest results?
body: <p>I have a table (several actually) that I want to get results from with the most recent entries first. Here are my <code>ORDER BY</code> clause options:</p>
  
  <ul>
  <li>date_created INT (never changes value)</li>
  <li>id (INT AUTO_INCREMENT of course!)</li>
  </ul>
  
  <p>Both columns should equally represent the order in which the records were inserted. I naturally would use the <code>date_created</code> field like any sane person would, but I'm still curious about this.</p>
  
  <p>I know this is probably splitting hairs, but is there any reason or edge case why I should NOT use the <code>id</code> column? </p>
  
  <p><strong>EDIT:</strong> I'm thinking that this question is vague as to which value we want to truly represent the insert order. Thank you for all your answers everybody, I am going to accept the best one and move on because I think I have made this difficult by assuming that ids will always be in order (see @Wrikken's comment). My gut instinct is that id should never be considered by the developer, which is what most of the answers here are pointing to.</p>