mysql substring和concat用法，substringconcat

mysql substring和concat用法，substringconcat

UPDATE invest_currents  SET  org_product_code=CONCAT(SUBSTRING(org_product_code FROM 1 FOR 8),'Y',SUBSTRING(org_product_code FROM 9));