写最简单的存储过程问题
刚学,我在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 ;