/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 votes201 views2 answers
Postgres set user as superuser
SQL
1 vote233 views1 answer
Print year of a date sql
SQL
0 vote208 views1 answer
How to use lower case in mysql
SQL
2 votes261 views1 answer
Mysql select true or false
SQL
1 vote217 views3 answers
Connection string mysql
SQL
0 vote201 views1 answer
Insert or update cassandra
SQL
0 vote216 views1 answer
ORACLE PARSE STRING
SQL
0 vote211 views1 answer
Postgressql uuid
SQL
2 votes225 views4 answers
Mysql get all tables row count
SQL
1 vote242 views1 answer
Mysql login console
SQL