Changing Column Defaults

To change column defaults, use the same form of the ALTER TABLE statement you use to create defaults.

For example, to change the default value of a column named order_date from its current setting to CURRENT DATE, use:
ALTER TABLE sales_order
MODIFY order_date DEFAULT CURRENT DATE
Parent topic: Column Defaults Encourage Data Integrity