mysql:difference_between_alter_change_and_modify_column
This is an old revision of the document!
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 |
mysql/difference_between_alter_change_and_modify_column.1479725169.txt.gz · Last modified: 2020/07/15 09:30 (external edit)