ALTER TABLE fm CHANGE suggestion suggestion MEDIUMTEXT (1000)
MySQL said: You have an error in your SQL syntax near '(1000) ' at line 1
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).
ALTER TABLE fm CHANGE suggestion suggestion MEDIUMTEXT;