how to add a new column to a table and add default value in mysql code example Example: mysql add column default value ALTER TABLE table1 ADD COLUMN foo INT DEFAULT 0;