/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 vote285 views1 answer
Select dba users oracle
SQL
-1 vote268 views1 answer
Export mysql table to file
SQL
4 votes269 views1 answer
Postgresql change default value
SQL
0 vote285 views1 answer
TSQL convert csv to table
SQL
5 votes292 views5 answers
Sqlite install python
SQL
1 vote269 views1 answer
Tsql random number
SQL
0 vote319 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote277 views2 answers
Login to mysql
SQL
0 vote224 views1 answer
Check id exist or not in sql
SQL
0 vote308 views2 answers
Oracle chain rules
SQL