/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

0 vote120 views1 answer
Inner joint
SQL
17 votes122 views3 answers
Cast in sql server
SQL
0 vote121 views1 answer
Check user sql password from command line
SQL
5 votes117 views2 answers
Ranking functions in sql
SQL
0 vote117 views1 answer
Sqlite version check
SQL
1 vote128 views1 answer
Alter constraint in sql
SQL
18 votes120 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote136 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
3 votes140 views3 answers
Mysql auto increment after delete
SQL
-1 vote125 views3 answers
Compute age mysql
SQL