Sqlite unique

sqlite uniue
-------------------------        
CREATE TABLE contacts(
  contact_id INTEGER PRIMARY KEY,
  first_name TEXT,
  last_name TEXT,
  email TEXT NOT NULL UNIQUE
);

Source: sqlitetutorial.net

SQLite UNIQUE

CREATE TABLE contacts(
    contact_id INTEGER PRIMARY KEY,
    first_name TEXT,
    last_name TEXT,
    email TEXT NOT NULL UNIQUE
);
Code language: SQL (Structured Query Language) (sql)

Source: sqlitetutorial.net

Similar codes

6 votes121 views2 answers
Mysql check auto increment value
SQL
1 vote120 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
0 vote127 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
1 vote144 views1 answer
Homebrew install mysql
SQL
0 vote118 views1 answer
Copying query result to excel
SQL
0 vote116 views1 answer
Suse status MySQL
SQL
10 votes128 views4 answers
Inner join in update query mysql
SQL
1 vote245 views3 answers
Sql subquery
SQL
0 vote122 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
29 votes111 views6 answers
Delete all rows from table mysql
SQL