mysql触发器

DELIMITER $$

USE `bsm_formal`$$

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

CREATE
    /*!50017 DEFINER = 'root'@'%' */
    TRIGGER `robot_user_trigger` AFTER INSERT ON `t_bsm_user` 
    FOR EACH ROW BEGIN
    INSERT INTO  t_bsm_ac (Id,NAME,contactPhone,isDisabled,dataFrom) VALUES (new.acId,new.phone,new.phone,new.isDisabled,'2');
    INSERT INTO  t_bsm_ac_platform (acId,VERSION,STATUS,registerTime,verifyTime) VALUES (new.acId,'1','2',new.registerTime,new.registerTime);
    END;
$$

DELIMITER ;