How to does IF not EXISTS in SQLite

Http://stackoverflow.com/questions/531035/how-to-do-if-not-exists-in-sqlite

How is this?

INSERT OR IGNORE INTO EVENTTYPE (EventTypeName) VALUES ‘ANI Received‘

(Untested as I don ' t have SQLite ... however this link is quite descriptive.)

Additionally, this should also work:

  insert  EventType  (eventtypenameselect  ' ANI Received ' < Span class= "KWD" >where not exists  (select 1from EventType where Eventtypename =  ' ANI Received '       

It is important to note that there is no values behind insert into.

Values are implemented through the following select.

Refer to this

Internal Static string Insertidxfile =@ "Insert into Sensordata (Id,projectid,sensoridx,idxfile,starttimestamp,endtimestamp) Select ' {0} ', ' {1} ', ' {2} ', ' {3} ', ' {4} ', ' {5} ' WHERE not EXISTS (SELECT 1 from sensordata where ID = ' {0} ')";

How to does IF not EXISTS in SQLite