mysql存储过程传入参数 实现动态列查询
一级标题DROP PROCEDURE IF EXISTS work_order_num;CREATE PROCEDURE work_order_num( IN proId VARCHAR(255), IN userName VARCHAR(64))BEGINSET @EE='';SET @proId = proId;SET @userName = userName;SELECT b.* into @EE from ( SELECT @EE:=CONCAT(@EE,'SUM(I
原创
2020-09-10 17:11:52 ·
878 阅读 ·
0 评论
关注
分享
扫一扫