How to do IF NOT EXISTS in SQLite

標籤：

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

How about 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 INTO EVENTTYPE (EventTypeName)SELECT ‘ANI Received‘WHERE NOT EXISTS (SELECT 1 FROM EVENTTYPE WHERE EventTypeName = ‘ANI Received‘);

需要注意的是，這裡的Insert Into後面是沒有Values；

Values是通過後面的Select來實現的

 

 

參考這個

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 do IF NOT EXISTS in SQLite