/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 vote173 views1 answer
Wordpress change url phpmyadmin
SQL
5 votes166 views1 answer
Oracle columns in all_tables
SQL
0 vote142 views1 answer
Multiple left join mysql
SQL
2 votes168 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote133 views1 answer
Sql check for null and empty string
SQL
2 votes153 views2 answers
Storing timezones in postgres
SQL
26 votes391 views6 answers
Modify column name in sql
SQL
1 vote150 views1 answer
Get create table query existing table mysql
SQL
0 vote176 views1 answer
Start stop mysql linux
SQL
0 vote163 views1 answer
Psql no such file or directory
SQL