title: Web SQL - Insert if not exists or Unique column?
body: <p>I try to execute <code>insert or ignore into  WDCategory(name,userID) values('Cate 1',1)</code> which name is a <code>unique</code> column but not successful if there is a record with same name in the table. "Not Successful" means that the query fail instead of execute and insert nothing. I have try <code>insert into  WDCategory(name,userID) values('Cate 1',1) If Not Exists</code> but nothing change.</p>
  
  <p>Update: I try 
  <code>insert or replace into  WDCategory(name,userID) values('Cate 1',1)</code>
  it works. But the record now have a new id (auto increase). Is there any way to keep the old values?</p>
  
  <p>Please help!</p>