title: Codeigniter 3 migrate sql
body: <p>I use Codeigniter 3 framework for my application, and i use the migration library. I write an object which is create a 'user_type' table, and insert into three row.</p>
  
  <p>Here is the code:</p>
  
  <pre><code>private $tableName = 'user_type';
  
  public function up() {
      $sql = "CREATE TABLE `$this-&gt;tableName` (
                  `id` TINYINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , 
                  `name` CHAR(120) NOT NULL
              ) ENGINE = InnoDB;";
  
      $sql .= "INSERT INTO `$this-&gt;tableName` (`id`, `name`) VALUES
                  (1, 'user'), (2, 'provider'), (3, 'admin');";
  
      $this-&gt;db-&gt;query($sql);
  }
  </code></pre>
  
  <p>If i want to use the migration, it drop an error message with this text:
  A Database Error Occurred</p>
  
  <blockquote>
    <p>Error Number: 1064</p>
    
    <p>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 'INSERT INTO <code>user_type</code> (<code>id</code>, <code>name</code>) VALUES (1, 'user'), (2,
    'provider')' at line 4</p>
    
    <p>CREATE TABLE <code>user_type</code> ( <code>id</code> TINYINT UNSIGNED NOT NULL
    AUTO_INCREMENT PRIMARY KEY , <code>name</code> CHAR(120) NOT NULL ) ENGINE =
    InnoDB;INSERT INTO <code>user_type</code> (<code>id</code>, <code>name</code>) VALUES (1, 'user'), (2,
    'provider'), (3, 'admin');</p>
    
    <p>Filename:
    C:/xampp/htdocs/rentacar/application/migrations/20151211113200_usertype_table_data.php</p>
    
    <p>Line Number: 18</p>
  </blockquote>
  
  <p>The interesting part of this, is if i echo the $sql variable, and run it in the phpmyadmin, it works well.</p>