/SQL/How to avoid duplicate records in sqlite

How to avoid duplicate records in sqlite

CREATE TABLE MAIN
   (
   NAME           TEXT    NOT NULL,
   Error_List          CHAR(50),
   Warning_List        CHAR(50),
   Advice_List         CHAR(50),
   Total          CHAR(50),
   Note           CHAR(50),
UNIQUE (NAME, Error_List, Warning_List, Advice_List, Total, Note) ON CONFLICT IGNORE
);

Source: stackoverflow.com

Similar codes

1 vote102 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
0 vote115 views1 answer
Create view in sql server that contain multiple select statements
SQL
0 vote153 views1 answer
Sql int vs integer
SQL
0 vote103 views1 answer
Select all columns except one sql
SQL
-1 vote55 views2 answers
On delete set default sql server
SQL
2 votes218 views5 answers
Unique in sql server
SQL
0 vote107 views1 answer
Split string by comma in sql server
SQL
6 votes100 views2 answers
Postgresql restore from dump
SQL
0 vote124 views1 answer
Ceil upto 2 decimal place mysql
SQL
11 votes106 views3 answers
Python sqlite3 create table if not exists
SQL