SQLyog不支持储存过程吗?
CREATE PROCEDURE TEST
(OUT NUMBER1 INTEGER)
BEGIN
DECLARE NUMBER2 INTEGER DEFAULT 100;
SET NUMBER1 = NUMBER2;
END;

相同的内容,在winsql里就可以运行正常.
但在SQLyog里就出错,为什么呢?
环境是5.0+winxp

[解决办法]
delimiter ||
CREATE PROCEDURE TEST
(OUT NUMBER1 INTEGER)
BEGIN
DECLARE NUMBER2 INTEGER DEFAULT 100;
SET NUMBER1 = NUMBER2;
END||
delimiter ;


(0 row(s)affected)
(0 ms taken)