/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

2 votes198 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
0 vote156 views1 answer
Create table Statement Syntax in SQL Server
SQL
0 vote166 views4 answers
Best data type to represent money in mysql
SQL
0 vote167 views1 answer
How to print sql query
SQL
5 votes166 views1 answer
Purge undo tablespace oracle 11g
SQL
1 vote172 views1 answer
Where database run
SQL
0 vote183 views1 answer
Datagrip execute procedure
SQL
13 votes120 views2 answers
Oracle all source
SQL
3 votes165 views2 answers
Mysql add 2 hours
SQL
0 vote185 views1 answer
Sql server list table sizes
SQL