/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

0 vote188 views1 answer
Postgresql remove new line from string
SQL
0 vote193 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
12 votes258 views2 answers
Find duplicates mysql column
SQL
0 vote140 views1 answer
Using GROUP BY in MySQL Join Table
SQL
1 vote228 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
4 votes142 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote166 views1 answer
Mysql regex select
SQL
0 vote157 views1 answer
Postgres statistics
SQL
2 votes155 views1 answer
Oracle apex list connected users
SQL
0 vote162 views1 answer
Automatically update database last seen datetime in sql
SQL