query add column integer nullable mysql default null code example Example: set column to not null mysql ALTER TABLE Person MODIFY P_Id INT(11) NOT NULL;