带有mySQL的存储过程，用于确定志愿者语言/方法插入不正确

DELIMITER //

CREATE PROCEDURE CheckVolunteerLanguage(IN volunteer_id INT, IN language VARCHAR(50), IN method VARCHAR(50))
BEGIN
    DECLARE language_exists INT;
    DECLARE method_exists INT;

    -- 检查语言是否存在
    SELECT COUNT(*) INTO language_exists FROM languages WHERE language_name = language;

    -- 检查方法是否存在
    SELECT COUNT(*) INTO method_exists FROM methods WHERE method_name = method;

    -- 如果语言或方法不存在，则进行相应处理
    IF language_exists = 0 THEN
        -- 处理语言不存在的情况
        INSERT INTO error_logs (volunteer_id, error_message) VALUES (volunteer_id, 'Invalid language');
    END IF;

    IF method_exists = 0 THEN
        -- 处理方法不存在的情况
        INSERT INTO error_logs (volunteer_id, error_message) VALUES (volunteer_id, 'Invalid method');
    END IF;
END //

DELIMITER ;