/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

7 votes190 views4 answers
Lowest salary in sql
SQL
0 vote205 views1 answer
Creating a simple notify in postgresql
SQL
0 vote187 views1 answer
Mysql isshow
SQL
0 vote218 views1 answer
Sql waitfor
SQL
0 vote216 views1 answer
Mysql date without time
SQL
0 vote189 views1 answer
Postgresql create table many-to-many
SQL
3 votes199 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote188 views1 answer
Sqldf change user
SQL
0 vote245 views1 answer
Turn on foreign keys check mysql
SQL
9 votes187 views2 answers
Nosql databases
SQL