Symfony2 Doctrine run SQL from a file in CLI
<p>I can use this to execute SQL at the CLI</p>

<pre><code>php app/console doctrine:query:sql "SELECT * FROM table"
</code></pre>

<p>But how can I use the same command to exec SQL from a file? E.g.</p>

<pre><code>php app/console doctrine:query:sql filename.sql
</code></pre>

<p>I have tried <code>&gt;</code> and <code>&lt;</code> in various ways and <code>cat</code> but nothing even comes close to doing what I want.</p>

<p>I realised I can use straight <code>mysql</code> to do this, but I wish to do it via doctrine.</p>