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

0 vote168 views1 answer
Mysql show schema
SQL
12 votes131 views1 answer
Script to add new column in table sql
SQL
0 vote121 views1 answer
Sql gap missing values
SQL
0 vote131 views1 answer
How to connect to mysql in ef 6
SQL
0 vote128 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote169 views1 answer
Sql check if field is not null
SQL
2 votes121 views1 answer
Pandas to sql index
SQL
1 vote137 views5 answers
What is in operator in sql
SQL
0 vote123 views1 answer
Back up stored procedures mysql
SQL
1 vote132 views1 answer
Quit mysql
SQL