/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

6 votes211 views2 answers
Install psql mac
SQL
49 votes209 views6 answers
Install mysql ubuntu
SQL
13 votes177 views6 answers
Current date sql
SQL
3 votes188 views3 answers
Postgresql random number
SQL
0 vote177 views1 answer
Select lowest values sql
SQL
0 vote193 views1 answer
Show tables in cassandra cql
SQL
2 votes178 views1 answer
Mysql virtual column
SQL
3 votes189 views1 answer
Oracle sql commit example
SQL
1 vote199 views1 answer
Opensuse restart MySQL
SQL
2 votes184 views4 answers
2nd highest salary in mysql
SQL