mysql add new column default null code example

Example 1: mysql add column default value

ALTER TABLE table1 ADD COLUMN foo INT DEFAULT 0;

Example 2: set column to not null mysql

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