Changing the default value of column in MySQL

After create table if you want to change default value for any column of table the we can use alter command in following way

Syntax

Example

above query will set default value for column_name to provided default value.