fyx912的专栏

CREATE DEFINER=`root`@`%` PROCEDURE `pro_user_ucwc_list_decId`()BEGIN    set @v_sql = concat("insert into t_alarm_log (devId,cvs,createDate) SELECT @devId:=devid , @cvs:=sum(vcs),curdate() FROM db

CREATE DEFINER=`root`@`%` PROCEDURE `pro_user_ucwc_list_decId`()BEGIN    set @v_sql = concat("insert into t_alarm_log (devId,cvs,createDate) SELECT @devId:=devid , @cvs:=sum(vcs),curdate() FROM db