/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 vote355 views1 answer
Drop CHECK constraint sql
SQL
0 vote337 views1 answer
How to check if there is no database schema
SQL
0 vote387 views1 answer
Get primary key of table
SQL
0 vote349 views1 answer
Contact mysql column field
SQL
1 vote363 views1 answer
Where date = max(date) in sql
SQL
7 votes324 views2 answers
Create index mysql
SQL
0 vote376 views1 answer
Mysql remove bad character from all fields
SQL
0 vote365 views1 answer
Add a new column into table
SQL
0 vote395 views1 answer
Sqlcl format
SQL
0 vote387 views2 answers
MySQL PARTITION BY month automatically
SQL