mysql add not null and unique constraint to existing column code example

Example: set column to not null mysql

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