ALTER TABLE - MODIFY COLUMN | MySQL | MYTAT

To change the data type of a column in a table, use the following syntax:

ALTER TABLE table_name
MODIFY COLUMN column_name datatype;

Practice Excercise Practice now