title: SQLite - Run multi-line SQL script from file?
body: <p>I have the following SQL in a file, user.sql:</p>
  
  <pre><code>CREATE TABLE user
  (
    user_id INTEGER PRIMARY KEY,
    username varchar(255),
    password varchar(255)
  );
  </code></pre>
  
  <p>However, when the following command is executed:</p>
  
  <pre><code>sqlite3 my.db &lt; user.sql 
  </code></pre>
  
  <p>The following error is generated:</p>
  
  <pre><code>Error: near line 1: near ")": syntax error
  </code></pre>
  
  <p>I would prefer to keep the SQL as-is, as the file will be checked into source control and will be more maintainable and readable as it is now. Can the SQL span multiple lines like this, or do I need to put it all on the same line? </p>