title: Naming the MYSQL id column
body: <p>What is the best practice for naming the column that is the primary key for a mysql table? I have seen two ways: </p>
  
  <ol>
  <li>'id' </li>
  <li>tableName_id (Where tableName is substituted for the name of the table). </li>
  </ol>
  
  <p>I would have thought just id would suffice, because you can still uniquely identify the column by selecting the column proceeded by a period and the table name (i.e. for the column 'id' in the table 'cars', you could select it as cars.id)</p>
  
  <p>Or am I over-thinking it all? </p>