/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

0 vote255 views1 answer
Mysql update even / odd rows
SQL
0 vote248 views1 answer
Getting next sequence value jpa postgress
SQL
0 vote296 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
0 vote257 views1 answer
PSQL qith variables
SQL
17 votes260 views6 answers
Get last record in sql
SQL
1 vote252 views1 answer
Sql trigger before delete
SQL
1 vote260 views1 answer
Mysql batch insert
SQL
0 vote259 views1 answer
Firebird where
SQL
0 vote262 views1 answer
Sql stored procedure update if parameter is not null
SQL
2 votes250 views1 answer
Oracle trace session
SQL