title: Drop All Tables Except One in MySql
body: <p>I have 100 tables in my database, I want to keep one only. </p>
  
  <p>I tried something like below query: </p>
  
  <pre><code>DROP ALL TABLES EXCEPT my_table
  </code></pre>
  
  <p>But that doesn't seem to exist. any idea?</p>