====== MySQL - Difference Between ALTER, CHANGE, and MODIFY COLUMN ======


^METHOD^DROP DEFAULT^CHANGE DEFAULT^RENAME COLUMN^CHANGE DATATYPE^COLUMN ORDER^
|ALTER|<color lime/black>Yes</color>|<color lime/black>Yes</color>|No|No|No|
|CHANGE|No|<color lime/black>Yes</color>|<color lime/black>Yes</color>|<color lime/black>Yes</color>|<color lime/black>Yes</color>|
|MODIFY|No|<color lime/black>Yes</color>|No|<color lime/black>Yes</color>|<color lime/black>Yes</color>|