mysql create column default value code example
Example 1: mysql add column default value
ALTER TABLE table1 ADD COLUMN foo INT DEFAULT 0;
Example 2: mysql default value
CREATE TABLE table_name(
column_name data_type,
Column_name data_type DEFAULT ‘value’
);