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);
Like this? Follow me ↯Tweet Follow @pfreitag
Change size of a varchar column with mysql was first published on October 17, 2005.