04 2013 档案
摘要:分隔字符串:CREATE DEFINER = root `@`%` FUNCTION `fun_string_split`(IN_IDS longText,IN_FIELD VARCHAR(64),IN_SPLIT VARCHAR(2))RETERNS LONGTEXTBEGIN DECLARE OUT_STRING LONGTEXT; DECLARE TMP_NEW_STRING LONGTEXT; SET TMP_FIND_POS = INSTR(IN_IDS,IN_SPLIT); IF(TMP_FIND_POS > 0) THEN SET OUT_STR...
阅读全文