mysql where column not null in another table code example
Example 1: set column to not null mysql
ALTER TABLE Person MODIFY P_Id INT(11) NOT NULL;
Example 2: mysql alter table column nullable
ALTER TABLE mytable MODIFY mycolumn VARCHAR(255);
ALTER TABLE Person MODIFY P_Id INT(11) NOT NULL;
ALTER TABLE mytable MODIFY mycolumn VARCHAR(255);