substring locate
时间：2010-08-19 来源：Zyy_Ivy
1. update ukms_prod_param set Desc_metric = substring( Desc_metric, locate ( ' ' , Desc_metric ) + 1 )
2. update ukms_prod_param set Desc_metric = substring( Desc_metric, 1, locate ( ':' , Desc_metric ) -1 )
3. update ukms_prod_param set Desc_metric = ( select Desc_metric from repax_prod_info_desc where repax_prod_info_desc.column_name = ukms_prod_param.Column_Name )
相关阅读 更多 +
