这个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
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
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 $$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 ;
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();
不然你要手动给他赋值。