DELIMITER $$
CREATE PROCEDURE students.getStudents (IN p_id INT, OUT p_full_name VARCHAR(30))
BEGIN
SELECT students.full_name INTO p_full_name
FROM students
WHERE students.id = p_id
END $$
DELIMITER ;
CREATE PROCEDURE students.getStudents (IN p_id INT, OUT p_full_name VARCHAR(30))
SELECT students.full_name INTO p_full_name
FROM students
WHERE students.id = p_id;
1条答案
按热度按时间bvhaajcl1#
您不需要在分隔符中重新分配和begin end块，因为您的过程只有一条语句：