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

-1 vote274 views2 answers
How to select the lowest values from table per client sql
SQL
0 vote274 views1 answer
How to set all the min and sec data to zero in sql server
SQL
17 votes269 views5 answers
Order by sql
SQL
0 vote300 views1 answer
How to print sql query
SQL
0 vote274 views1 answer
Ignore case in string sql
SQL
14 votes302 views2 answers
Oracle limit rows
SQL
0 vote288 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
1 vote288 views1 answer
Where to locate set password for mysql
SQL
0 vote261 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote278 views1 answer
Import big data to mysql
SQL