title: symfony2 migrations sql file
body: <p>I want update my trigger from live, and I want to know if I can use migrations for that because I tried 2 alternative in my migrations:</p>
  
  <pre><code>public function up(Schema $schema)
      {
          // this up() migration is auto-generated, please modify it to your needs
          $this-&gt;abortIf($this-&gt;connection-&gt;getDatabasePlatform()-&gt;getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
  
          $stmt = $this-&gt;connection-&gt;prepare(file_get_contents(__DIR__ . '/Version20150929103205/new_trigger_procedure.sql'));
          $stmt-&gt;execute();
  
          $this-&gt;addSql(file_get_contents(__DIR__ . '/Version20150929103205/new_trigger_procedure.sql'));
      }
  </code></pre>
  
  <p>but not work. My sql file have multiple declaration. Is a possibility to run it with migrations?</p>
  
  <p>Here is a model:</p>
  
  <p><code>DROP TRIGGER IF EXISTS trigger_1;
  Create Trigger trigger_1 BEFORE...
  DROP Trigger IF EXISTS trigger_2;
  Create Trigger trigger_2 Before ...
  .
  .
  .
  </code></p>