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

3 votes213 views3 answers
Start postgresql ubuntu
SQL
0 vote209 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
5 votes264 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
0 vote213 views1 answer
Codigo crear tablas sql server
SQL
0 vote197 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
0 vote198 views1 answer
Postgres statistics
SQL
0 vote204 views1 answer
Mysql get first 2 characters of string
SQL
0 vote196 views1 answer
Oracle simple quote
SQL
104 votes1.1K views2 answers
Like in mysql
SQL
-2 votes197 views1 answer
Remove root password mysql
SQL