日期:2014-05-16  浏览次数:20621 次

写最简单的存储过程问题
刚学,我在phpAdmin或MySQL.com下的MyQueryBrowser工具中写下面存储过程
Create   Procedure   `p_Department_Insert`
(
    iParentClassCode     bigint(20),
    cName     varchar(45)
)
Begin
    Select   iParentClassCode;
End;

提示错误如下:
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   'Select   iParentClassCode '   at   line   7

帮帮忙,谢谢了

------解决方案--------------------
DELIMITER $$

CREATE PROCEDURE `p_Department_Insert`
(
iParentClassCode bigint(20),
cName varchar(45)
)
BEGIN
Select iParentClassCode;
END$$

DELIMITER ;