/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

18 votes146 views6 answers
Creating table in MySQL
SQL
0 vote117 views1 answer
Sql table to store status
SQL
0 vote158 views1 answer
Enable sql server full text indexing
SQL
1 vote130 views1 answer
Oracle finding duplicate records
SQL
0 vote154 views1 answer
Datagrip go to line
SQL
0 vote165 views2 answers
Sql query print strings and int
SQL
1 vote140 views1 answer
How to delete a record from sqlite in android
SQL
1 vote185 views1 answer
Mysql print variable
SQL
0 vote139 views2 answers
Functions with parameters SQL
SQL
5 votes148 views3 answers
Oracle first day of last year
SQL