这个mysql存储过程哪里有错，高手指教

[John1202]

这个mysql存储过程哪里有错，高手指教

create procedure sp_insert_depart(
in dep_name varchar(50),
in dep_memo varchar(50),
out Result int
)
BEGIN
INSERT INTO tbl_depart(departid,departname,departmemo) values (null,dep_name,dep_memo);
set Result = LAST_INSERT_ID();
END;

SQL 查询:

CREATE PROCEDURE sp_insert_depart( IN dep_name varchar( 50 ) , IN dep_memo varchar( 50 ) , out Result int ) BEGIN INSERT INTO tbl_depart( departid, departname, departmemo )
VALUES (

NULL , dep_name, dep_memo
);



MySQL 返回：

#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 7

[rucypli]

set Result = LAST_INSERT_ID();之前没有定义这个Result啊

[雪狐晨光]

我也是初学者 过来看看~

[ACMAIN_CHM]

delimiter //

create procedure sp_insert_depart(
in dep_name varchar(50),
in dep_memo varchar(50),
out Result int
)
BEGIN
INSERT INTO tbl_depart(departid,departname,departmemo) values (null,dep_name,dep_memo);
set Result = LAST_INSERT_ID();
END;
//

[WWWWA]

如果是在MYSQL命令行下输入：
delimiter $$

create procedure sp_insert_depart(
in dep_name varchar(50),
in dep_memo varchar(50),
out Result int
)
BEGIN
INSERT INTO tbl_depart(departid,departname,departmemo) values (null,dep_name,dep_memo);
set Result = LAST_INSERT_ID();
END;$$
delimiter ;

[yq510457]

楼上正解！

[huabing84]

如果你的departid是自增的话，把
INSERT INTO tbl_depart(departid,departname,departmemo) values (null,dep_name,dep_memo);
set Result = LAST_INSERT_ID();
修改成
INSERT INTO tbl_depart(departname,departmemo) values (dep_name,dep_memo);
set Result = LAST_INSERT_ID();
不然你要手动给他赋值。