Change size of a varchar column with mysql

October 17, 2005 by Pete Freitag

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);