/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

4 votes197 views1 answer
Is there any command to change postgres password
SQL
2 votes180 views1 answer
Find all triggers in database
SQL
0 vote186 views2 answers
How to use aggregate functions in sql
SQL
5 votes208 views5 answers
Find max number in sql
SQL
0 vote205 views1 answer
C# select Mysql
SQL
0 vote282 views1 answer
Print hello world in plsql
SQL
0 vote180 views1 answer
Select only one row sql
SQL
5 votes194 views1 answer
Sql table columns
SQL
0 vote176 views1 answer
SQL column name Oracle
SQL
0 vote187 views1 answer
Drop-toys-table
SQL