/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

18 votes166 views2 answers
Sql inner join
SQL
1 vote181 views1 answer
Sql find column name like
SQL
0 vote166 views1 answer
Delete double on SQL with multiple primary keys
SQL
1 vote158 views1 answer
How to delete data from sql database in android
SQL
0 vote247 views1 answer
Run docker container with database as rds metabase
SQL
0 vote199 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
-1 vote154 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
0 vote199 views1 answer
Nodejs sql get one to many relationship as array
SQL
2 votes161 views1 answer
Sql like variable
SQL
0 vote171 views1 answer
Less than and between in sql query
SQL