![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
文章平均质量分 80
禽兽猿
这个作者很懒,什么都没留下…
展开
-
mysql游标
UPDATE activities set keyword = REPLACE(keyword,',',','); DROP PROCEDURE IF EXISTS myCursor; CREATE PROCEDURE myCursor() BEGIN DECLARE done INT DEFAULT 0 ; DECLARE tmpName VARCHAR(255) DE原创 2016-01-02 00:12:42 · 388 阅读 · 0 评论 -
mysql触发器
更新 DROP TRIGGER IF EXISTS `t_afterupdate_on_activities`; CREATE TRIGGER t_afterupdate_on_activities AFTER UPDATE ON activities FOR EACH ROW BEGIN SET @newkeywords = new.keyword; SET @oldkeyw原创 2016-01-02 00:17:35 · 373 阅读 · 0 评论