title: how to reindex mysql table
body: <p>I have a table with many rows but they are out of order. Im using the field "id" as the primary key. I also have a "date" field which is a datetime field.</p>
  
  <p>How could i reindex the table so that the entries are id'd in chronological order according to the date field</p>