mysql 传入参数存储过程

最新推荐文章于 2024-09-24 22:33:45 发布

taiweipeng

最新推荐文章于 2024-09-24 22:33:45 发布

阅读量737

点赞数

分类专栏： MySql 文章标签： mysql 传入存储过程

本文链接：https://blog.csdn.net/taiweipeng/article/details/84811985

版权

MySql 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

DROP PROCEDURE IF EXISTS `sp_InsertCustomerOnline`;
CREATE PROCEDURE `sp_InsertCustomerOnline`(IN `in_cid` int,IN `in_pKey` varchar(20),in_serverkey varchar(20),IN `in_logintime` datetime,IN `in_ip` varchar(16),IN `in_token` varchar(36))
BEGIN
DECLARE tcount int default 0;
select count(token) into tcount from ser_CustomerOnline where Token=in_token;
if(tcount=0)THEN
insert into ser_CustomerOnline(customerid,serverkey,product,LoginTime,RefreshTime,IP,Token)VALUES(in_cid,in_serverkey,in_pKey,in_logintime,in_logintime,in_ip,in_token);
ELSE
update ser_CustomerOnline set serverkey=in_serverkey, product =in_pKey,LoginTime =in_logintime,RefreshTime=in_logintime,Ip=in_ip where Token =in_token ;
end if;
END