How to update a column of char type in mysql to increase its length

Question

How to increase the length of a column with char data type in mysql ?

The following query

ALTER TABLE tablename ALTER COLUMN columnname varchar(30) not null;

is not working.

Point out my error please. Thanks

you can refer this http://stackoverflow.com/questions/7513513/increasing-size-of-varchar-column-on-a-large-table-any-problems — SRIRAM, Oct 19 '12 at 11:35

score 9 · Accepted Answer · answered Oct 19 '12 at 11:34

9

ALTER TABLE `tablename` CHANGE `columnname` `columnname` VARCHAR( 30 ) NOT NULL

OR

ALTER TABLE `tablename` MODIFY `columnname` VARCHAR( 30 ) NOT NULL

answered Oct 19 '12 at 11:34

PyQL

score 1 · Answer 2 · edited Oct 19 '12 at 13:51

1

please try query given below

ALTER TABLE tablename  MODIFY  columnname varchar(30) NOT NULL;

You can refer to this tutorial

edited Oct 19 '12 at 13:51

Alexis Pigeon

answered Oct 19 '12 at 11:40

Er. Anurag Jain

2 Answers2