title: mysql innodb indexing confused
body: <p>I am building a mysql table:  ID (auto int), cc char(9), tt int(11), mm char(3)</p>
  
  <p>Now I have set the ID to be the primary index.</p>
  
  <p>Every query will be either select or update with WHERE id='numberhere' LIMIT 1. (so its just 1 row at a timw ever needed)</p>
  
  <p>Now, To get the correct performance benifit from using innodb, do I just leave ID as primary and only index in the table? or should I set everything as an index?  I am unsure...</p>
  
  <p>EDIT: no joins in the table, it is literally SELECT * FROM table WHERE id='2341...' everytime
  or same but with update...</p>