title: Nodejs sequelize how to truncate a foreign key referenced table
body: <p>[Important: this is only relevant for Sequelize Version &lt; 3]</p>
  <p>I have a &quot;myTable&quot; mysql table in which myTable.id is referenced by a foreign key on another table. I need to truncate &quot;myTable&quot;. Normally with mysql shell I would do:</p>
  <pre><code>mysql&gt; SET FOREIGN_KEY_CHECKS = 0; truncate table myTable; SET FOREIGN_KEY_CHECKS = 1;
  </code></pre>
  <p>Is there any way of doing this with sequelize?</p>
  <p>I have tried to execute</p>
  <p><code>sequelize.query('SET FOREIGN_KEY_CHECKS = 0; truncate table myTable; SET FOREIGN_KEY_CHECKS = 1;')</code></p>
  <p>but I have the error:</p>
  <pre><code>`Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'truncate table myTable; SET FOREIGN_KEY_CHECKS = 1' at line 1`
  </code></pre>
  <p>If I execute the queries serially, I cannot truncate the table:</p>
  <pre><code>ERROR 1701 (42000): Cannot truncate a table referenced in a foreign key constraint
  </code></pre>