/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 vote317 views1 answer
Casterar postgres
SQL
2 votes346 views1 answer
Revokeprivileges mysql
SQL
1 vote312 views1 answer
Neo4j display all nodes and relationships
SQL
5 votes313 views1 answer
Ascending order and where in sql
SQL
0 vote356 views1 answer
Prisma transaction
SQL
0 vote332 views1 answer
Function plsql
SQL
1 vote384 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote316 views2 answers
T SQl Checking Your Username
SQL
0 vote341 views1 answer
Postgresql cast as year and month from timestamp
SQL
0 vote299 views1 answer
Downgrading sql localdb visual studio
SQL