Bill MacKenty

  Home     Computing     Teaching     Bushcraft     Games     Writing     About  

MYSQL: changing a field type to longtext

Posted in HOWTO general computing Personal on 03 - December 2010 at 11:33 AM (13 years ago). 373 views.

Note to self:

To change a mysql filedtype from mediumtext to longtext simply type:


ALTER TABLE exp_templates CHANGE template_data template_data longtext;

This will change the field “template_data” in the table “exp_templates” to longtext.

Hope this helps someone.