/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 vote200 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote205 views1 answer
Sql show all users
SQL
0 vote208 views1 answer
Frename oracle
SQL
0 vote204 views1 answer
Storing RGBA in mysql db
SQL
1 vote221 views1 answer
How to fetch alternate records from two tables
SQL
0 vote201 views1 answer
Recover deleted data from mysql database
SQL
0 vote210 views1 answer
Query params sql insert python f string
SQL
0 vote216 views1 answer
SQL Server rename foreign key constraint
SQL
11 votes216 views3 answers
Pl sql example
SQL
0 vote214 views1 answer
I wanted to select among the rows the highest value in mysql
SQL