存储过程

最新推荐文章于 2024-04-22 08:00:00 发布

金麟十三少

最新推荐文章于 2024-04-22 08:00:00 发布

阅读量233

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/u012373281/article/details/77929467

版权

mysql 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

CREATE PROCEDURE `get_client_rank`(IN user_type_cd VARCHAR(6),IN client_id INT)
BEGIN
set @mycnt = 0;
SELECT a.rank FROM (
SELECT t.id,(@mycnt := @mycnt + 1) as rank FROM clients t INNER JOIN user_points ut on t.id=ut.user_id where ut.user_type_cd=user_type_cd ORDER BY ut.points desc )
a where a.id=client_id ORDER BY id;
END

CREATE PROCEDURE `get_supplier_rank`(IN user_type_cd VARCHAR(6),IN supplier_id INT)
BEGIN
set @mycnt = 0;
SELECT a.rank FROM (
SELECT t.id,(@mycnt := @mycnt + 1) as rank FROM suppliers t INNER JOIN user_points ut on t.id=ut.user_id where ut.user_type_cd=user_type_cd ORDER BY ut.points desc )
a where a.id=supplier_id ORDER BY id;
END

CREATE PROCEDURE `get_cart_rank`(IN user_type_cd VARCHAR(6),IN cart_id INT)
BEGIN
set @mycnt = 0;
SELECT a.rank FROM (
SELECT t.id,(@mycnt := @mycnt + 1) as rank FROM cart t INNER JOIN user_points ut on t.id=ut.user_id where ut.user_type_cd=user_type_cd ORDER BY ut.points desc )
a where a.id=cart_id ORDER BY id;
END