mysql change column to accept null code example

Example 1: postgresql change column to not null

-- To change a column to NOT NULL:
ALTER TABLE products ALTER COLUMN product_no SET NOT NULL;

Example 2: set column to not null mysql

ALTER TABLE Person MODIFY P_Id INT(11) NOT NULL;