title: Cannot truncate a table referenced in a foreign key constraint
body: <p>Cannot truncate a table referenced in a foreign key constraint.
  What should i do first to enable truncate?</p>
  <p>details:</p>
  <pre><code>(
      `guacamole`.`guacamole_connection_history`, 
      CONSTRAINT `guacamole_connection_history_ibfk_2` 
      FOREIGN KEY (`connection_id`) 
      REFERENCES `guacamole`.`guacamole_connection` (`connection_id`)
  )
  </code></pre>
  <p>I want to clear guacamole_connection table for development testing.</p>
  <p><a href="https://i.stack.imgur.com/Rx5zg.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Rx5zg.jpg" alt="DB structure" /></a></p>