title: How to paste multiline SQL statements into the sqlite3 shell
body: <p>I use a script to generate CREATE statements for tables and want to paste these statements into the SQLite command shell. Unfortunately it does not work as expected, because the line break seems to cause trouble.</p>
  
  <p>When I copy the following example table </p>
  
  <pre><code>CREATE TABLE ExampleTable (
      columnA INTEGER, 
      columnB VARCHAR(2), 
      columnC INTEGER
  );
  </code></pre>
  
  <p>into the SQLite command shell, I get this result:</p>
  
  <pre><code>sqlite&gt;     CREATE TABLE ExampleTable (
     ...&gt; 
  </code></pre>
  
  <p>and the shell waits for input until I press the semicolon (;). Is this linked to the separator? I tried setting it to ';' manually but there was no effect. I would expect the shell to accept the commands regardless of the format of its input string. The very same command works for instance in the Firefox Addon SQLite Manager, also I could read them from a file. For the quick test nevertheless, I would rather just paste the CREATE statements. I am sure that is a very easy thing to do, I just could not find the proper hint. Thanks!</p>