/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

-1 vote289 views1 answer
Default username and password for oracle 11g
SQL
0 vote315 views1 answer
Postgresql alter table sequence
SQL
0 vote268 views2 answers
Return the number of records in a single table mysql
SQL
0 vote293 views1 answer
Shrink database file in sql server
SQL
1 vote286 views1 answer
How to get previous year from sysdate in oracle
SQL
7 votes273 views6 answers
Nth highest salary in sql
SQL
1 vote256 views1 answer
Postgres format date in select
SQL
0 vote267 views2 answers
Mysql to python pandas
SQL
150 votes495 views10 answers
Grepper
SQL
0 vote276 views1 answer
Flask sqlalchemy remove duplicates
SQL