我在写一个存储过程的时候，遇到了一个错误，“delimiter”在这个位置是无效的，希望创建“。我想这可能是MySQL workbench的一个问题，因为下面的代码给出了同样的错误，但是是直接从这个网站上复制的。

DELIMITER $$
CREATE PROCEDURE GetTotalOrder()
BEGIN
    DECLARE totalOrder INT DEFAULT 0;
    
    SELECT COUNT(*) 
    INTO totalOrder
    FROM orders;
    
    SELECT totalOrder;
END$$
DELIMITER ;

编辑：我的真实存储过程是：

DELIMITER //
CREATE PROCEDURE GetSimilar(inputdate char(10))
BEGIN
    Declare id(tinyint) DEFAULT 0;
    Set id := (select t.IdTimelineinfo
        From timelineinfo t
        WHERE t.Date = inputdate);
    SELECT t.Date From timelineinfo t where t.date = inputdate;
    SELECT o.Name, o.Race, o.Sex, o.IdOfficer
        FROM timelineinfo
        JOIN timelineinfo_officer ON timelineinfo.IdTimelineinfo = timelineinfo_officer.IdTimelineinfo      
        JOIN officers o ON timelineinfo_officer.IdOfficer = o.IdOfficer
        WHERE timelineinfo.IdTimelineinfo = id
        UNION
    SELECT s.IdSubject, s.Name, s.Race, s.Sex
        FROM timelineinfo
        JOIN timelineinfo_subject ON timelineinfo.IdTimelineinfo = timelineinfo_subject.IdTimelineinfo      
        JOIN subjects s ON timelineinfo_subject.IdSubject = s.IdSubject
        WHERE timelineinfo.IdTimelineinfo = id;
        UNION
    Select * 
        From media m
        Where (m.IdTimelineinfo = id);
END //
DELIMITER ;