Change size of a varchar column with mysql

You can use the ALTER TABLE command to change the size of a column. Suppose you want to change the size of a varchar column from 50 character to 100 characters, simply run the following SQL statement:

ALTER TABLE tablename MODIFY columnname varchar(100);