limited time offer

Is primary key contain null value ?

A PRIMARY KEY column is equivalent to UNIQUE and NOT NULL and is indexed column by default. It should be UNIQUE because a primary key identifies rows in a table so 2 different row should not have the same key.

In addition a primary key may be used as a FOREIGN KEY in other tables and that's why it cannot be NULL so that the other table can find the rows in the referenced table.