mysql触发器在一个表上插入的同时修改本表的数据

DELIMITER $$


USE `cric_crm`$$


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


CREATE
    /*!50017 DEFINER = 'leju'@'%' */
    TRIGGER `insert_on_t_report_pdetails_day` BEFORE INSERT ON `t_report_pdetails_day` 
    FOR EACH ROW BEGIN
     DECLARE in_sort INT(3) DEFAULT 999 ;
     SET in_sort = (SELECT sort FROM t_report_pdetails_day WHERE orgstr=new.orgstr LIMIT 1);
      SET new.sort=in_sort ;
    END;
$$


DELIMITER ;