title: Is column order important in mysql?
body: <p>I read somewhere that column order in mysql is important. I believe they were referring to the indexed columns.</p>
  
  <p><strong>QUESTION:</strong> If column order is important, when and why is it important?</p>
  
  <p>The reason I ask is because I have a table in mysql similar to the one below.
  The primary index is on the left and I have an index on the far right. Is this bad?
  It is a MyISAM table and will be used predominantly for selects (no inserts, deletes or updates).</p>
  
  <pre><code>-----------------------------------------------
  |  Primary index | data1|  data2  | d3| Index |
  -----------------------------------------------
  |      1         |   A  |   cat   | 1 |   A   | 
  |      2         |   B  |  toads  | 3 |   A   |
  |      3         |   A  |  yabby  | 7 |   B   |
  |      4         |   B  | rabbits | 1 |   B   |
  -----------------------------------------------
  </code></pre>