IN()在mysql存储过程中不起作用 [英] IN() not working in mysql stored procedure

问题描述

DELIMITER $$

USE `employee`$$

DROP PROCEDURE IF EXISTS `selectemployeebyids`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `selectemployeebyids`(IN empid VARCHAR(100))
BEGIN
    SELECT empname,salary,department from emp where empid IN (empid) ORDER BY empid;
    END$$

DELIMITER ;

谁能帮我

Manju K

Can anyone please help me

Manju K

推荐答案

USE `employee`

USE `employee`

DROP 过程 IF

DROP PROCEDURE IF EXISTS `selectemployeebyids`

程序`selectemployeebyids`( IN empid VARCHAR ( 100 )) 开始 选择 empname，薪水，部门来自 emp 其中 empid 输入(empid) ORDER BY 温柔 END

CREATE DEFINER=`root`@`localhost` PROCEDURE `selectemployeebyids`(IN empid VARCHAR(100)) BEGIN SELECT empname,salary,department from emp where empid IN (empid) ORDER BY empid; END

这篇关于IN()在mysql存储过程中不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！