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_idEND $$DELIMITER ;
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 ;
bvhaajcl1#
您不需要在分隔符中重新分配和begin end块，因为您的过程只有一条语句：
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;
WHERE students.id = p_id;
1条答案
按热度按时间bvhaajcl1#
您不需要在分隔符中重新分配和begin end块，因为您的过程只有一条语句：