MySQL - Difference Between ALTER, CHANGE, and MODIFY COLUMN
METHOD
DROP DEFAULT
CHANGE DEFAULT
RENAME COLUMN
CHANGE DATATYPE
COLUMN ORDER
ALTER
Yes
Yes
No
No
No
CHANGE
No
Yes
Yes
Yes
Yes
MODIFY
No
Yes
No
Yes
Yes