BEGIN
SET @count=100;
IF @count=100 || @count=300 THEN
SET @count=11;
ELSEIF @count=2 THEN
SET @count=3;
END IF;
SELECT @count; #查看运行结果
END
MySQL存储过程-IF与ELSE
最新推荐文章于 2024-06-29 13:56:33 发布
BEGIN
SET @count=100;
IF @count=100 || @count=300 THEN
SET @count=11;
ELSEIF @count=2 THEN
SET @count=3;
END IF;
SELECT @count; #查看运行结果
END