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 :
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 ?