数据库实现拼音缩写

DELIMITER $$

USE `mypos`$$

DROP TRIGGER /*!50032 IF EXISTS */ `updatepysx`$$

CREATE

    TRIGGER `updatepysx` BEFORE INSERT ON `spb`

    FOR EACH ROW BEGIN

                 SET new.spmcsx=qjp(new.spmc);

    END;

$$

DELIMITER ;

DELIMITER $$

USE `mypos`$$

DROP TRIGGER /*!50032 IF EXISTS */ `updatepysx1`$$

CREATE

    TRIGGER `updatepysx1` BEFORE UPDATE ON `spb`

    FOR EACH ROW BEGIN

        IF (old.spmc != new.spmc) THEN

                 SET new.spmcsx=qjp(new.spmc);

        END IF;

    END;

$$

DELIMITER ;

CREATE DEFINER=`root&