Add a column with a default value to an existing table in MYSQL

DEFAULT fills the column in existing rows with the default value

Example:



Alter table with Default Value..

Example:

ALTER table seasonhead ADD TESTID int NOT NULL DEFAULT 5