1 修改已有表中某个字段的长度
alter table noticeinfo
MODIFY province varchar(4000);
alter table noticeinfo
MODIFY province varchar(4000);
COMMIT;
2 选择时限制不为空
"select distinct dzh,gslb from qhgsfuturetype where dzh is not null and gslb is not null";