create procedure stc_info(in Tid char(8), in type int, out info varchar(10)) IF type = 1 then set info = CAST((select count(Tno) from stc where Tno=Tid group by Tno) AS CHAR) 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 6 时间: 0s为什么错了

这个错误可能是因为 IF 语句没有结束。可以尝试通过以下方式修改代码：

create procedure stc_info(in Tid char(8), in type int, out info varchar(10)) 
BEGIN
    IF type = 1 THEN
        set info = CAST((select count(Tno) from stc where Tno=Tid group by Tno) AS CHAR);
    END IF;
END;

在存储过程中，需要使用 BEGIN 和 END 来标记 IF 语句的开始和结束。这样可以避免语法错误。