/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

2 votes134 views1 answer
Coalesce sql
SQL
0 vote128 views1 answer
Mysql custom sort order
SQL
0 vote119 views1 answer
Get primary key of table
SQL
0 vote121 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote124 views1 answer
Yesql
SQL
0 vote121 views1 answer
Mysql grant grant option
SQL
0 vote105 views1 answer
Get who is hired in month in sql
SQL
1 vote155 views1 answer
Apex run 404
SQL
-2 votes124 views2 answers
Add auto_increment column to existing table mysql
SQL
4 votes118 views6 answers
Second max salary in sql
SQL