(MySql) Why NOT NULL add to primary key field?

Question

Why NOT NULL add to primary key field?(primary key is already not null+unique)

Example for NOT NULL id field:

create table student
(
 id int(11) AUTO_INCREMENT NOT NULL,
 name varchar(255),
 PRIMARY KEY(id)
)

Instead Just:

create table student
(
 id int(11) AUTO_INCREMENT,
 name varchar(255),
 PRIMARY KEY(id)
)

Edit: I add AUTO_INCREMENT.

Thansk

Answer 1

NULL is not equivalent to NULL(as NULL indicates an unknown or absent value), so you will be permitted to have multiple records that have NULL for the id, even though there's a primary key / unique constraint defined, hence the use of NOT NULL. That's if MySql even allows you to define a primary key on a nullable field.

In addition, as a primary key is often used in a foreign key in other tables, having one or more NULL values wouldn't make sense.

Answer 2

They are the same. Primary key got NOT NULL automatically.

Answer 3

You are asking, why do people bother adding the NOT NULL when it is unnecessary? Just because it is good style, I guess. And makes it explicit to the reader.