Increasing a column/field length in MySQL

[PixelStreamed]

i need to increase a column/field length from 100 to 150 in MySQL. how do i do this? any help would be appreciated...thanks in advance.

[arran]

Hi PixelStreamed,

ALTER TABLE <table name> MODIFY <column name> VARCHAR(150)

Either that or use php my admin - select the column, click the pencil, update the 'length/values' field to 150 and click save.

arran.

References - [dev.mysql.com ]