/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 votes171 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
0 vote177 views1 answer
Sql search all columns of database oracle sql
SQL
10 votes186 views6 answers
Between sql
SQL
3 votes176 views1 answer
Oracle drop user
SQL
1 vote174 views1 answer
Input in mysql
SQL
0 vote221 views1 answer
Change redo log file size in mysql 5.6
SQL
4 votes191 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote163 views1 answer
Sql server split string and insert into table select
SQL
5 votes174 views1 answer
How to check nls format in oracle
SQL
-1 vote216 views4 answers
Postgres between dates
SQL