-- 大表删除、修改某些字段以便添加默认字段能够顺利进行 update xwcmdbfieldinfo SET DBLENGTH = 3000 WHERE TABLENAME = 'GovInfo' AND FIELDNAME = 'RelPhoto'; update xwcmviewfieldinfo SET DBLENGTH = 3000 WHERE TABLENAME = 'GovInfo' AND DBFIELDNAME = 'RelPhoto'; alter table wcmmetatableGovInfo MODIFY COLUMN `RelPhoto` varchar(3000) NULL DEFAULT ''