How to do IF NOT EXISTS in SQLite

by

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");

More Related Contents:

  1. Selecting more than one value
  2. Is it possible to insert multiple rows at a time in an SQLite database?
  3. SQLite DateTime comparison
  4. SQLite Reset Primary Key Field
  5. SQLite INSERT – ON DUPLICATE KEY UPDATE (UPSERT)
  6. What are valid table names in SQLite?
  7. Deleting duplicate rows from sqlite database
  8. What does the SQL Standard say about usage of backtick(`)?
  9. Delete column from SQLite table
  10. Declare variable in SQLite and use it
  11. Does SQLite3 not support foreign key constraints?
  12. sqlite database default time value ‘now’
  13. How do I insert datetime value into a SQLite database?
  14. How to get a list of column names on Sqlite3 database?
  15. basic recursive query on sqlite3?
  16. SQLite and custom order by
  17. SQLite auto-increment non-primary key field
  18. GROUP_CONCAT in SQLite
  19. Match only entire words with LIKE?
  20. What is causing Foreign Key Mismatch error?
  21. Android multiple databases open
  22. How to split comma-separated values?
  23. sqlite select with condition on date
  24. How to compare sqlite TIMESTAMP values
  25. SQlite: select into?
  26. SQLite Order By Date1530019888000
  27. SQL – Inserting a row and returning primary key
  28. IF() statement alternative in SQLite
  29. UPSERT *not* INSERT or REPLACE
  30. Copy table structure to new table in sqlite3

Leave a Comment