![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
fyx_912
这个作者很懒,什么都没留下…
展开
-
mysql 存储过程动态执行sql
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原创 2016-07-04 17:10:58 · 778 阅读 · 0 评论 -
mysql 定时执行存储过程
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原创 2016-07-04 17:47:53 · 618 阅读 · 0 评论