How can I modify the size of column in a mysql table?

Use the following mysql command to increase the size of a column


mysql> alter table Table change column columnname columnname varchar(size);


Before:

mysql> describe Foo;

+--------------------------+--------------+------+-----+---------+-------+

| Field                    | Type         | Null | Key | Default | Extra |

+--------------------------+--------------+------+-----+---------+-------+

| name                     | varchar(255) | NO   | PRI | NULL    |       |

| comments                 | varchar(255) | YES  |     | NULL    |       |

+--------------------------+--------------+------+-----+---------+-------+

Run command:

mysql> alter table Foo change column comments comments varchar(1000); 

After:

mysql> describe Foo;

+--------------------------+--------------+------+-----+---------+-------+

| Field                    | Type         | Null | Key | Default | Extra |

+--------------------------+--------------+------+-----+---------+-------+

| name                     | varchar(255) | NO   | PRI | NULL    |       |

| comments                 | varchar(1000)| YES  |     | NULL    |       |

+--------------------------+--------------+------+-----+---------+-------+