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