Mysql rename vs modify column

08-06-2019
To change the name of a column: ``` ALTER TABLE tableName CHANGE `oldcolname` `newcolname` datatype(length); ``` To modify it's type or nullable: ``` ALTER TABLE tableName MODIFY col datatype(length) not null; ```