mysql - 最后一个分号的程序如何解决？

Question

我在结束之前的行有问题，结束分号发生了一些问题，我收到的消息如下:

CREATE PROCEDURE emp_info(IN p_first_name varchar(255), IN p_last_name varchar(255), OUT p_emp_no integer) BEGIN SELECT e.emp_no INTO p_emp_no FROM employees e WHERE e.first_name = p_first_name AND e.last_name = p_last_name Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 9

use employees;
drop procedure if exists emp_info;

CREATE PROCEDURE emp_info(IN p_first_name varchar(255), IN p_last_name varchar(255), OUT p_emp_no integer)
BEGIN
    SELECT
        e.emp_no
    INTO p_emp_no FROM
        employees e
    WHERE
        e.first_name = p_first_name
            AND e.last_name = p_last_name;
END$$

DELIMITER ;

Answer 1

您忘记以 DELIMITER $$ 开头并在 END $$ 之间留一个空格会有所帮助

drop procedure if exists emp_info;

DELIMIER $$

CREATE PROCEDURE emp_info(IN p_first_name varchar(255), IN p_last_name varchar(255), OUT p_emp_no integer)
BEGIN
    SELECT
        e.emp_no
    INTO p_emp_no FROM
        employees e
    WHERE
        e.first_name = p_first_name
            AND e.last_name = p_last_name;
END $$

DELIMITER ;