mysql:difference_between_alter_change_and_modify_column
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.txt · Last modified: 2020/07/15 09:30 by 127.0.0.1