/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 votes158 views1 answer
Python sql
SQL
0 vote133 views1 answer
Soql update query
SQL
4 votes126 views2 answers
Oracle default date format
SQL
0 vote90 views1 answer
Sql count how many times a value appears
SQL
0 vote138 views1 answer
Create column that already exists mysql
SQL
0 vote196 views1 answer
How to add auto increment primary key
SQL
1 vote351 views1 answer
How to make a select in sql
SQL
1 vote95 views2 answers
Last working day in week date function in sql
SQL
0 vote141 views1 answer
Sql select all records from all tables where not empty
SQL
1 vote142 views3 answers
How to truncate table with foreign key constraint
SQL