/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

3 votes271 views1 answer
Set default today mysql
SQL
0 vote296 views1 answer
Add user mysql wordpress
SQL
1 vote266 views1 answer
Check if mysql is installed
SQL
0 vote284 views1 answer
Sql missing values
SQL
1 vote278 views3 answers
Union in sql
SQL
0 vote269 views1 answer
Oracle array
SQL
0 vote273 views1 answer
Copy data from one postgres container to another
SQL
1 vote302 views1 answer
Concat first name and last name in mysql
SQL
3 votes250 views2 answers
Oracle sql truncate table
SQL
0 vote262 views1 answer
Sql column as header
SQL