/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

3 votes284 views1 answer
Oracle list invalid password ORA-01017
SQL
2 votes274 views1 answer
Postgresql add entry to table
SQL
0 vote282 views1 answer
Unique element in sql
SQL
0 vote285 views1 answer
Trigger stock phpmyadmin output message
SQL
5 votes282 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote333 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
0 vote291 views2 answers
Sqlalchemy core in clause
SQL
1 vote305 views1 answer
Oracle sql pad left zeros
SQL
0 vote326 views1 answer
Oracle chain step succeeded
SQL
0 vote310 views1 answer
Oracle session statistics
SQL