/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 vote398 views1 answer
Mysql convert charset
SQL
6 votes380 views6 answers
Rename column postgres
SQL
0 vote342 views1 answer
Get initials name in sql
SQL
2 votes338 views1 answer
Mysql change data type of column
SQL
1 vote312 views1 answer
Mysql server does not start mac
SQL
1 vote358 views1 answer
Mysql print variable
SQL
2 votes340 views1 answer
Sql finding longest and shortest names in a fleld
SQL
18 votes339 views6 answers
Creating table in MySQL
SQL
3 votes308 views1 answer
Mysql UPDate with enner join
SQL
0 vote357 views1 answer
Mysql add to number
SQL