title: Best practices for ordering columns in SQL when creating the table
body: <p>I have a table foo which contains the following columns</p>
  
  <pre><code>create table foo (
  id integer not null auto_increment unique,
  name varchar(255),
  desc varchar(255),
  modified_time datetime not null,
  type tinyint(1)
  )
  </code></pre>
  
  <p>Are there any best practices in following a ordering convention for all the columns (e.g. in a alphabetical fashion or not nulls at the top and rest of the columns at the bottom)</p>