SQLite3 UNIQUE constraint failed error

by

You get a UNIQUE constraint failed error when the data that you are inserting has an entry which is already in the corresponding column of the table that you are inserting into.

If you want SQL to IGNORE that error and continue adding other records , then do this : 

INSERT or IGNORE into tablename VALUES (value1,value2 , so on );

If you want to replace the values in the table whenever the entry already exists , then do this:

INSERT or REPLACE into tablename VALUES (value1,value2 , so on );

This saves lot of processing on your part and quite useful.

More Related Contents:

  1. How can I list the tables in a SQLite database file that was opened with ATTACH?
  2. SQLite INSERT – ON DUPLICATE KEY UPDATE (UPSERT)
  3. Deleting duplicate rows from sqlite database
  4. SQLite – How do you join tables from different databases?
  5. Does SQLite3 not support foreign key constraints?
  6. SQLite – ORDER BY RAND()
  7. How to get a list of column names on Sqlite3 database?
  8. Drop all tables command
  9. Core Data Performance with Single Parent Entity
  10. Android multiple databases open
  11. sqlite select with condition on date
  12. Copy table structure to new table in sqlite3
  13. SQL Data models
  14. What’s the difference between TRUNCATE and DELETE in SQL
  15. single fixed table with multiple columns vs flexible abstract tables
  16. How do I insert datetime value into a SQLite database?
  17. How to design a database for User Defined Fields?
  18. Normalization in plain English
  19. How to do IF NOT EXISTS in SQLite
  20. Oracle – How to create a materialized view with FAST REFRESH and JOINS
  21. How to Optimize Queries in a Database – The Basics
  22. Bulk/batch update/upsert in PostgreSQL
  23. How to populate calendar table in Oracle?
  24. Create date from day, month, year fields in MySQL
  25. Grant privileges for a particular database in PostgreSQL
  26. How do I change db schema to dbo
  27. What is the best way to implement soft deletion?
  28. PostgreSQL how to create a copy of a database or schema?
  29. Query a Table’s Foreign Key relationships
  30. Postgres: convert single row to multiple rows (unpivot)

Leave a Comment