56,677
社区成员
发帖
与我相关
我的任务
分享
DELIMITER $$
DROP PROCEDURE IF EXISTS `gettest`$$
CREATE PROCEDURE `gettest`(out _ppp varchar(20))
SQL SECURITY INVOKER
BEGIN
set _ppp = ( select deptName from interview_department where taskCode='11221111' and deptCode='302079' limit 1 );
select _ppp;
END$$
DELIMITER ;
call gettest(@q);
select @q;