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 vote180 views1 answer
How to combine rows in sql server procedure
SQL
0 vote176 views1 answer
Selecting all columns from table sql database
SQL
0 vote177 views1 answer
Connect laravel to mysql on mac
SQL
1 vote165 views2 answers
Check if word is in column sql
SQL
0 vote162 views1 answer
Mysql random number between 1 and 100
SQL
2 votes155 views1 answer
Mysql add boolean column
SQL
0 vote167 views1 answer
Sql out file formate
SQL
1 vote201 views1 answer
Top 10 rows in mysql
SQL
16 votes170 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
0 vote167 views1 answer
How to move a column to different spot mysql
SQL