/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 votes109 views1 answer
Mysql virtual column
SQL
4 votes105 views2 answers
Insert current date in mysql
SQL
0 vote115 views1 answer
How to get specific salary in sql
SQL
1 vote105 views3 answers
Union SQL
SQL
0 vote104 views1 answer
Print orcale
SQL
8 votes105 views2 answers
Mysql query dates between two dates
SQL
53 votes283 views6 answers
How to install mysql ubuntu
SQL
1 vote124 views2 answers
Copy table in sql
SQL
0 vote110 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
4 votes127 views3 answers
NOT NULL SQL
SQL