title: How to write cratedb migration scripts ? Migration Scripts not working
body: <p>we have a database which has a table called Students with columns id,name,age,school. </p>
  
  <p>Now i want to write a migration script to copy 3 columns (lets assume i have millions of records) from Students table to New_students table . </p>
  
  <p>Below is my sample script which i have written . It is throwing an error</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS New_Students (
  id PRIMARY KEY,
  name string,
  age string,
  )
  
  INSERT INTO New_Students(id,name,age)
  SELECT  id,name,age
  FROM students;
  </code></pre>
  
  <p>When executed above in crateDb Admin UI, i get below error</p>
  
  <pre><code>SQLActionException[SQLParseException: line 8:1: mismatched input 'INSERT' expecting &lt;EOF&gt;]
  </code></pre>
  
  <p>The above statements works when executing individually .</p>
  
  <p>Question:</p>
  
  <ol>
  <li>Why is above multiple statements are not working , but it works when typed individually ?
  2.How to do we copy data from table columns to another new table . Let us say i have millions of records , how do i do it more efficiently ?</li>
  </ol>