Unique vs primary key

What is the difference between UNIQUE and PRIMARY KEY constraints? 
There should be only one PRIMARY KEY 
in a table whereas there can be
any number of UNIQUE Keys.
PRIMARY KEY doesn’t allow NULL
values whereas Unique key allows NULL values.

Similar codes

4 votes322 views1 answer
Mysql ip address data type
SQL
7 votes319 views2 answers
Add column table pl sql
SQL
2 votes290 views1 answer
Convert series number to date in sql
SQL
49 votes366 views6 answers
Get duplicate records in sql
SQL
1 vote313 views1 answer
Postgresql contains
SQL
0 vote328 views2 answers
Psql commande \gset
SQL
1 vote318 views3 answers
Mysql Server Start
SQL
0 vote311 views2 answers
Laravel: customize or extend notifications - database model
SQL
-1 vote305 views3 answers
Check table exist postgresql
SQL
0 vote300 views1 answer
What is between operator
SQL