/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 vote237 views1 answer
Check for directory in bash
SQL
1 vote184 views1 answer
Postgres grant read only access to database
SQL
3 votes252 views6 answers
Jwt laravel
SQL
0 vote234 views2 answers
Sqlalchemy core in clause
SQL
0 vote249 views1 answer
Date datatype in livesql
SQL
0 vote269 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote215 views1 answer
Rabbitmq service not starting
SQL
0 vote213 views1 answer
Stop psql server windows
SQL
0 vote230 views1 answer
Mariadb date equals to current_date plus days
SQL
0 vote222 views1 answer
Sql inserted
SQL