MySQL 简单存储过程实现Redis的INCR功能

最新推荐文章于 2022-08-21 13:39:41 发布

weixin_30611509

最新推荐文章于 2022-08-21 13:39:41 发布

阅读量279

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/xiaoit/p/4576790.html

版权

USE test;

DROP PROCEDURE IF EXISTS pro_testincrement;
DELIMITER &&
CREATE PROCEDURE pro_testincrement(IN inr int)
BEGIN
DECLARE i INT DEFAULT 0;
select max(id) into i from test.testpro;
update test.testpro set id = id+inr where id = i;
select max(id) from test.testpro;
END && 
DELIMITER ;


mysql> call pro_testincrement (3);
+---------+
| max(id) |
+---------+
| 68 |
+---------+
1 row in set (0.01 sec)

Query OK, 0 rows affected (0.01 sec)

mysql> call pro_testincrement (3);
+---------+
| max(id) |
+---------+
| 71 　　  |
+---------+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> call pro_testincrement (1);
+---------+
| max(id) |
+---------+
| 72      |
+---------+
1 row in set (0.02 sec)

Query OK, 0 rows affected (0.02 sec)

转载于:https://www.cnblogs.com/xiaoit/p/4576790.html