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 [table name] 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.
