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

0 vote112 views1 answer
Ffeathers express mysql application users login
SQL
0 vote104 views1 answer
Sql select non unique
SQL
-1 vote125 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
10 votes97 views5 answers
Mysql create user
SQL
2 votes106 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
1 vote103 views1 answer
Mysql select if empty result
SQL
1 vote110 views1 answer
Postgresql transaction discard all
SQL
2 votes93 views1 answer
Mysql list users on ubuntu
SQL
8 votes116 views1 answer
Mysql restore database
SQL
244 votes188 views14 answers
Sql n insert
SQL