/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 vote148 views1 answer
Python connect to mysql in settings.py
SQL
2 votes182 views2 answers
Create table mysql integer NOT null
SQL
0 vote158 views1 answer
SQL Where-Klausel
SQL
0 vote120 views1 answer
Mysql update sequence with order by
SQL
1 vote125 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
0 vote130 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote128 views1 answer
Get employees if not contains in sql
SQL
0 vote121 views1 answer
Check sql database table lock
SQL
3 votes127 views1 answer
Show index table
SQL
1 vote141 views1 answer
Difference between where and having clause
SQL