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 vote329 views1 answer
How to open mysql in docker
SQL
6 votes351 views2 answers
Insert into select mysql
SQL
2 votes328 views1 answer
Sql missing records from another table
SQL
18 votes302 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
0 vote334 views1 answer
Select multiple row from primary key sql
SQL
0 vote332 views1 answer
Dump multiple tables mysql
SQL
2 votes321 views1 answer
How to add where command in update comand with joins
SQL
0 vote366 views1 answer
Creating sqeuence in oracle database
SQL
2 votes346 views1 answer
Datetrunc
SQL
7 votes346 views3 answers
Sql server reset auto increment
SQL