![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
存储过程
ButterFly1024
要获得自己从未有过的东西,必须拼了命去做自己从未做过的事情
展开
-
mysql 定时器调用存储过程
#存储过程,更改7天外用户状态# DELIMITER $$ CREATE PROCEDURE temp() BEGIN UPDATE zy_developer SET regstatus=1 WHERE TIMESTAMPDIFF(DAY,STR_TO_DATE(TIME,'%Y-%m-%D'),CURDATE()) >=7; COMMIT; END $$ DELIMITER; #原创 2014-04-16 10:10:56 · 4579 阅读 · 1 评论 -
oracle 定时器调用存储过程
创建存储过程create or replace PROCEDURE addupoperate AS BEGIN insert into imp_operatequantity(pck,screen,click,download,setup,gysdkv,time,appid) select pck,screen, click,download,setup,gysdkv,time,appid原创 2014-04-15 15:53:47 · 3020 阅读 · 0 评论