how to add a new column to a table with default in mysql code example

Example: mysql add column default value

ALTER TABLE table1 ADD COLUMN foo INT DEFAULT 0;