/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

1 vote375 views1 answer
Mysql count all table rows
SQL
2 votes349 views1 answer
How to check grants on a package in oracle
SQL
0 vote364 views1 answer
View t-sql mail configuration
SQL
3 votes366 views4 answers
Ubuntu stop mysql
SQL
1 vote358 views1 answer
Sql server cast date dd/mm/yyyy
SQL
2 votes324 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
3 votes370 views1 answer
Only join in sql
SQL
0 vote364 views1 answer
Sqlite insert or update
SQL
0 vote330 views1 answer
Sql get table last modified time
SQL
0 vote367 views1 answer
Groupby sort sql hive
SQL