title: Mysql: Which to use when: drop table, truncate table, delete from table
body: <p>List the differences between the following MySql commands.</p>
  
  <ul>
  <li>drop table <em>tablename</em>;</li>
  <li>truncate table <em>tablename</em>;</li>
  <li>delete from <em>tablename</em> where 1; </li>
  </ul>
  
  <p>Also from your experiences please tell me typical usage scenario for each.</p>