title: Can't truncate MySQL table, while being able to delete all the records
body: <p>I'm a very beginner to relations, so this may sound dumb. But, what is the difference (in MySQL) between truncating a table and removing all the records (<a href="https://stackoverflow.com/a/21206090/1469208">this</a> answer says only about performance)?</p>
  
  <p>I was playing (in phpMyAdmin) with one of my test tables, to check, how can I reset <code>auto_increment</code> value of table and run into situation, where I was able to delete all the records:</p>
  
  <pre><code>DELETE from managers;
  </code></pre>
  
  <p>But when I tried to truncate this table (<code>TRUNCATE managers</code>), I've got warning: <code>Cannot truncate a table referenced in a foreign key constraint (probes, CONSTRAINT probes_ibfk_4 FOREIGN KEY (manager_id) REFERENCES managers (id));</code>.</p>
  
  <p>I had to "reset" the <code>auto_increment</code> value with <code>ALTER TABLE managers AUTO_INCREMENT = 1;</code>.</p>
  
  <p>Isn't that something odd? Up until now, I thought, that <code>TRUNCATE</code> = <code>DELETE from managers</code> (in terms of checking and effects, because performance can be different, but this is not the key here).</p>
  
  <p>How can constraint warning pop on <code>TRUNCATE</code> but not on "delete all"?</p>