/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

8 votes129 views2 answers
Mysql query dates between two dates
SQL
1 vote149 views1 answer
Sql server kill all connections
SQL
2 votes139 views1 answer
Express api ith mysql data
SQL
0 vote128 views1 answer
Psql datestyle
SQL
0 vote127 views1 answer
Sql random decimal
SQL
13 votes138 views2 answers
Get date from now() mysql
SQL
9 votes153 views4 answers
Last mysql
SQL
0 vote128 views1 answer
Excute raw query
SQL
11 votes132 views1 answer
Mysql order by two columns priority
SQL
1 vote185 views1 answer
Size of all tables in a schema oracle
SQL