触发器：自动更新编号，小编辑也可以触发更新（创彩）

lingdang

解决办法：

drop trigger if exists update_account_no;

delimiter ||

CREATE TRIGGER update_account_no BEFORE UPDATE ON ld_accountscf

FOR EACH ROW

BEGIN

select concat(DATE_FORMAT(createdtime,'%Y%m%d'),'_',account_no) into @num from ld_account where accountid=OLD.accounti

d;

select concat(NEW.cf_1514,'_',@num) into @new_no;

set NEW.cf_1529=@new_no;

END ||

delimiter;

drop trigger if exists update_salesorder_no;

delimiter ||

CREATE TRIGGER update_salesorder_no BEFORE UPDATE ON ld_salesordercf

FOR EACH ROW

BEGIN

select concat(DATE_FORMAT(createdtime,'%Y%m%d'),'_',salesorder_no) into @num from ld_salesorder where salesorderid=OLD.salesorderid;

select concat(NEW.cf_1476,'_',NEW.cf_1459,'_',NEW.cf_1462,'_',@num) into @new_no;

set NEW.cf_1528=@new_no;

END ||

delimiter ;