title: Truncate all tables in MySQL database that match a name pattern
body: <p>I need to clear all my inventory tables.</p>
  
  <p>I've tried this:</p>
  
  <pre><code>SELECT 'TRUNCATE TABLE ' + TABLE_NAME
  FROM INFORMATION_SCHEMA.TABLES
  WHERE TABLE_NAME LIKE 'inventory%'
  </code></pre>
  
  <p>But I get this error:</p>
  
  <pre><code>Truncated incorrect DOUBLE value: 'TRUNCATE TABLE ' Error Code 1292
  </code></pre>
  
  <p>if this is the correct way, then what am I doing wrong?</p>