mysql update varchar length on table column code example

Example: syntax for changing column size in mysql

ALTER TABLE emp MODIFY COLUMN name VARCHAR(100);