/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 vote312 views1 answer
Install postgresql on raspberry pi
SQL
0 vote314 views1 answer
Import big data to mysql
SQL
3 votes312 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
-1 vote335 views3 answers
MySQL shutdown unexpectedly
SQL
0 vote333 views1 answer
Apex for oracle 11g
SQL
0 vote339 views1 answer
Is not numeric sql
SQL
0 vote379 views1 answer
Delete ids between sql
SQL
0 vote300 views1 answer
Sqlserver now
SQL
7 votes316 views3 answers
Restore postgres database from sql file
SQL
4 votes328 views2 answers
Sql offset
SQL