在mysql中创建过程时出错

Question

create procedure temp (in empId int)
begin
 declare emptype varchar;
    select emptype = qoute(emptype) from dms_document where id =  empid;
    select emptype

 case  
when emptype = 'P' then
    select doctype from dms_report where pilot = 1
else
select 'No Documents required'
end case
end;

这是我在MySQL中创建过程的查询，我在case语句中得到了错误--请告诉我为什么会出现这个错误--为什么要在工作台中声明

Answer 1

在这里，我格式化了您的过程使用delimiter

DELIMITER //
CREATE PROCEDURE temp ( empId INT)
    BEGIN
     DECLARE var_etype VARCHAR(36);

SELECT 
    emptype = QOUTE(emptype)
FROM
    dms_document
WHERE
    id = empid;
SELECT 
    emptype,
    CASE
        WHEN emptype = 'P' THEN doctype
        ELSE 'No Documents required'
    END
FROM
    dms_report
WHERE
    pilot = 1;
End//
DELIMITER ;

Answer 2

你被逗号挂念了。

    CREATE PROCEDURE temp (IN empId INT)
        BEGIN
         DECLARE emptype VARCHAR;
            SELECT emptype = qoute(emptype) FROM dms_document WHERE id =  empid;
                SELECT emptype,

     CASE  
    WHEN emptype = 'P' THEN doctype;

    ELSE 'No Documents required';
    END CASE ;
    FROM dms_report WHERE pilot = 1
End;