increasing length of the field

[yalini]

hi,

I set a very small field length in mysql table and now i like to increase the field length.

would anybody plz help me.

thank u,
:mad: yalini

[bokeh]

What is the data type?

[jeny]

hi,

if u want to alter the data type then

ALTER table <table_name> modify <column_name> <char_lenght)
eg:
ALTER table customer modify Addr char(30)

hope u got it....

[yalini]

hi,

thanks jeny

yalini :D

[yalini]

Hi,

data type I used is varchar.

thanks a lot,
yalini

[nabeelisnabeel]

Check the table in mySQL interface and click the EDIT (or Change) link.and edit the ield length.

[The Little Guy]

are you using MySQL? if so, do you have PHP MyAdmin? You can edit it in there if you do.

[vdedaniya]

Hi,

Why you ppl are not using "SQLyog", its Free MySQL GUI Windows Manager Management Client Tool

You can download "SQLyog" from the URL: http://www.webyog.com/download.php?id=270086

Vishal

[bokeh]

Hi,

data type I used is varchar.

thanks a lot,
yaliniHave you fixed this already? If not did you want more than 255 characters? If so you will need to change data type (maybe to text) ALTER TABLE tablename CHANGE COLUMN column_name column_name TEXT