DELIMITER $$
USE `mypos`$$
DROP TRIGGER /*!50032 IF EXISTS */ `update_spb_spmc`$$
CREATE
/*!50017 DEFINER = 'root'@'localhost' */
TRIGGER `update_spb_spmc` BEFORE UPDATE ON `spb`
FOR EACH ROW BEGIN
DECLARE n_spmc VARCHAR(20);
DECLARE str VARCHAR(4);
DECLARE mcsp VARCHAR(20)DEFAULT '';
DECLARE str2 VARCHAR(4);
DECLARE n_length INT(4);
DECLARE i INT(4) DEFAULT 1;
SET n_spmc=new.spmc;
SET n_length=CHAR_LENGTH(n_spmc);
WHILE i<=n_length DO
SET str=SUBSTRING(n_spmc,i,1);
SELECT jp INTO str2 FROM hzpy WHERE hz=str;
SET mcsp=CONCAT(mcsp,str2);
SET i=i+1;
END WHILE;
SET new.spmcsx=mcsp;
END;
$$
DELIMITER ;