/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

5 votes323 views1 answer
Add column table sql default value
SQL
1 vote294 views1 answer
Copy postgres table from one schema into another
SQL
0 vote293 views1 answer
Oracle procedure chain step
SQL
1 vote292 views1 answer
Postgres convert exisiting column to text
SQL
1 vote274 views1 answer
Select statement to print longest name
SQL
5 votes307 views3 answers
Mysql remove unique constraint
SQL
1 vote276 views1 answer
Limit offset order by mysql
SQL
0 vote293 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote324 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote302 views1 answer
Difference between min and max date sql
SQL