Alter, change, MODIFY in MySQL

ALTER TABLE project_listCHANGE COLUMN descriptionofproj proj_desc VARCHAR(100),CHANGE COLUMN contractoronjob con_name VARCHAR(30);

MODIFY: Use it to modify only the type of the column without interfering with its name, assuming you want to change the character length of the Proj_desc column to varchar (120) to accommodate more descriptive text, as long as you do so.

ALTER TABLE project_listMODIFY COLUMN proj_desc VACHAR(120);#proj_desc是要修改的列名，VARCHAR(120)是新的数据类型。

summarized as follows;
(1) Change both the column name and the type
(2) Only modify the type, with modify

Alter, change, MODIFY in MySQL