/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

9 votes208 views4 answers
Mysql set id auto increment
SQL
2 votes214 views1 answer
Oracle trace file
SQL
0 vote187 views1 answer
Postgres : ERROR: division by zero
SQL
31 votes190 views3 answers
Sql count(*)
SQL
1 vote201 views1 answer
Best configuration for display table in sqlplus
SQL
6 votes194 views1 answer
Update left join mysql
SQL
2 votes193 views1 answer
Mysql last 7 days including today
SQL
2 votes198 views1 answer
Select * from table where name like
SQL
0 vote282 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
1 vote204 views3 answers
How to truncate table with foreign key constraint
SQL