Definition: You can use the modify SQL command if you need to resize a column in MySQL. By doing this you can allow more or less characters than before. It is written as: alter table
modify [column name] VARCHAR(5) ;
Also Known As: Modify Column, Resize Column
Examples:
alter table people modify name VARCHAR(35) ;
This changes the column called "name" on the table called "people" to now allow 35 characters.
