Alter Table

[vikaspa]

CHANGE THE WIDTH OF COULM USING phpMyAdmin


In casea field is varchar I can change its width from 50 to 200 (max 255 is pemitted)

However when I change varchar(200) to Mediumtext(1000) it gives error

as follow :
Error
SQL-query:

ALTER TABLE fm CHANGE suggestion suggestion MEDIUMTEXT (1000)
MySQL said: You have an error in your SQL syntax near '(1000) ' at line 1
Back


I wantr to make the sizie of field 'suggestion' from varchar(200) to 1000 what is the way ?

[Spookster]

Try removing the column and then adding it with the datatype and size that you want.

[mbenson]

ALTER TABLE fm CHANGE suggestion suggestion MEDIUMTEXT (1000)
MySQL said: You have an error in your SQL syntax near '(1000) ' at line 1
Back


I wantr to make the sizie of field 'suggestion' from varchar(200) to 1000 what is the way ? [/B]

Try not telling it to use mediumtext (1000). MySQL uses that type column as a field up to 16.8MB (16000000 chars or something).

just use:
ALTER TABLE fm CHANGE suggestion suggestion MEDIUMTEXT;