title: mysql naming convention
body: <p>I have generally always used some sort of <code>Hungarian Notation</code> for my field names in my tables e.g.</p>
  
  <pre><code>#Table Users
  u_id, u_name, u_email etc...
  
  #Posts
  p_id, p_u_id, p_title, p_content etc...
  </code></pre>
  
  <p>But I have recently been told that this isn't best practice. Is there a more standard way of doing this? I haven't really liked just using the field <code>id</code> as this is then requirs you to select <code>table</code>.<code>field</code> for fields names that appear in mutliple tables when using joins etc.</p>
  
  <p>Your thoughts on what is best practice would be appreciated.</p>