title: SQLite trigger insert error
body: <p>So I have a mysql database the works with this trigger</p>
  
  <pre><code>delimiter $$
  create trigger update_memberID
  after update on memberdata  
  for each row
  Begin
  if not (new.visits &lt;=&gt; old.visits) then
    insert into membervisit (memberID) values (new.memberID);
    end if;
  if not (new.memberID &lt;=&gt; old.memberID) then
   update membervisit set memberID = new.memberID where memberID =     old.memberID;
    end if;
  end$$
  delimiter ;
  </code></pre>
  
  <p>Now I am trying to setup the same database on SQLite and everything but this trigger is working. the code I have for the SQLite trigger is </p>
  
  <pre><code>"CREATE TRIGGER IF NOT EXISTS `membership.update_memberID` " +
  " AFTER UPDATE " +  
  " ON memberdata " +
  " FOR EACH ROW BEGIN " +       
  " SELECT CASE WHEN (new.visits &lt;= old.visits) THEN " +
      " INSERT INTO 'membership.membervisit' ('memberID') values (new.memberID);" +
              "END;\n" +
  
  " SELECT CASE WHEN (new.memberID &lt;= old.memberID) THEN " +
      "UPDATE `membership.membervisit` SET `memberID` = `new.memberID` WHERE `memberID` =`old.memberID`;" +
              "END;" +
  "END;"
  </code></pre>
  
  <p>The error I receive is </p>
  
  <pre><code>Exception in thread "main" java.sql.SQLException: near "INSERT": syntax error
      at org.sqlite.core.NativeDB.throwex(NativeDB.java:397)
      at org.sqlite.core.NativeDB._exec(Native Method)
      at org.sqlite.jdbc3.JDBC3Statement.executeUpdate(JDBC3Statement.java:116)
      at SQLiteSetup.main(SQLiteSetup.java:62)
  C:\Users\Owner\AppData\Local\NetBeans\Cache\8.1\executor-snippets\run.xml:53: Java returned: 1
  BUILD FAILED (total time: 0 seconds)
  </code></pre>
  
  <p>The insert it refers to is </p>
  
  <pre><code>" INSERT INTO 'membership.membervisit' ('memberID') values (new.memberID);"
  </code></pre>
  
  <p>Any help would be appreciated
  Thanks</p>