CREATE PROCEDURE `Test`( )
BEGIN
SET @max_update =(select max(plan_period) FROM 表名);
SET @plan_period = '2022-08-22' ;
IF @max_update = @plan_period
THEN
select 2;
ELSE
SELECT 1;
END IF;
END
12-09
7862
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
CREATE PROCEDURE `Test`( )
BEGIN
SET @max_update =(select max(plan_period) FROM 表名);
SET @plan_period = '2022-08-22' ;
IF @max_update = @plan_period
THEN
select 2;
ELSE
SELECT 1;
END IF;
END