CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `ManageMentUserAdd`(UserName varchar(40),CategoryId varchar(15),out n int(11)) BEGIN INSERT INTO `managementuser` ( `UserName`, `CategoryId`, ) VALUES ( UserName, CategoryId, ); set n = last_insert_id(); select n; END */;;但是 SELECT N 取不到 返回是插入成功1
INSERT INTO `managementuser`(`UserName`,`CategoryId`,)VALUES(UserName,CategoryId,);两个问题。语法上不对,多了个,另外你确认你的记录插入成功了吗?
删了字段没去掉,插入肯定成功了 就是取不到最后的ID OUT N 可以取到,就是 SELECT的取不到 返回是插入成功记录数1
INSERT .....
SET N= last_insert_id();
SELECT N
BEGIN
INSERT INTO `managementuser`
(
`UserName`,
`CategoryId`,
)
VALUES
(
UserName,
CategoryId,
);
set n = last_insert_id();
select n;
END */;;但是 SELECT N 取不到 返回是插入成功1