Run multiple sql queries with CodeIgniter migrations

migrations.php

/*
Assuming you have an SQL file (or string) you want to run as part of the migration, which has a number of statements...
CI migration only allows you to run one statement at a time. If the SQL is generated, it's annoying to split it up and create separate statements.
This small script splits the statements allowing you to run them all in one go.
*/

$sqls = explode(';', $sql);
array_pop($sqls);

foreach($sqls as $statement){
	$statment = $statement . ";";
	$this->db->query($statement);	
}

"simple_query" is a better choice than query() in this use case.