/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 vote271 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
16 votes212 views2 answers
Mysql date between two dates
SQL
1 vote191 views1 answer
Add current timestamp in mysql
SQL
17 votes260 views4 answers
Show all tables in oracle
SQL
4 votes185 views2 answers
DB::transaction
SQL
0 vote194 views5 answers
Select concat alter table mysql
SQL
0 vote203 views1 answer
Object of class mysqli_result could not be converted to string
SQL
0 vote195 views1 answer
Create date sql
SQL
0 vote202 views1 answer
Sql select upcoming birthdays
SQL
6 votes183 views3 answers
Mysql first day of year
SQL