/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 votes182 views4 answers
Print pl sql
SQL
1 vote196 views3 answers
How to reset id column in sql server
SQL
2 votes295 views2 answers
How to DROP a table in mysql
SQL
-1 vote242 views1 answer
Add 10 to all numbers in a column sql
SQL
3 votes195 views1 answer
Postgres add not null to existing column
SQL
0 vote256 views1 answer
Call function sql oracle with output put line
SQL
0 vote186 views1 answer
Sql contains vs like
SQL
0 vote169 views1 answer
Opensuse stop MySQL
SQL
2 votes174 views1 answer
Sqlplus clear screen
SQL
1 vote189 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL