1.修改字段类型和长度语句
alter table test modify(name varchar(255));
MySQL的修改字段类型语句 alter table test modify column name varchar(255);
2.substring indexof 应用
update table_name set table_name.column_name = replace(table_name.column_name,'str1','str2'); 其中str1是待替换的内容,str2 是替换后的内容;
select replace(t.params,substr(t.params,instr(t.params,'SNMP_PORT='),instr(t.params,';COMMAND_PORT')-instr(t.params,'SNMP_PORT=')),'SNMP_PORT=80') from res_dev t;