Forum Moderators: open

Message Too Old, No Replies

Increasing a column/field length in MySQL

         

PixelStreamed

1:01 am on Nov 14, 2005 (gmt 0)

10+ Year Member



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

1:11 am on Nov 14, 2005 (gmt 0)

10+ Year Member



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 ]