How to remove not null constraint in MySQL

In this post we will see how we can remove not null constraint in MySQL.

Not null constraints can be removed by using the Alter command. We have to modify the column to remove the not null constraint.

Syntax

Alter table table_name Modify column_name;

Example

Alter table address Modify empid int;