56,677
社区成员
发帖
与我相关
我的任务
分享
DELIMITER $$
DROP PROCEDURE IF EXISTS `test`.`test_proc`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `test_proc`(IN aaa VARCHAR(50), IN bbb VARCHAR(200), OUT ccc INTEGER(11))
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ' '
BEGIN
select count(1) from test where bbb=bbb into @cnt;
if @cnt > 1 then
set ccc = -1;
else
insert into test(aaa,bbb)
values (aaa,bbb);
set ccc = 0;
end if;
END$$
DELIMITER ;