CREATE PROCEDURE `pmp`.`GetSerialNumber` (out serialNo VARCHAR(3))
BEGIN
SELECT @cnt:=count(*) FROM Seek where Year = YEAR(CURRENT_DATE());
if (@cnt > 0) then
update Seek SET SeekNo=SeekNo+1 WHERE Year=YEAR(CURRENT_DATE());
Else
INSERT INTO Seek(Year,SeekNo) values (YEAR(CURRENT_DATE()),0);
end if;
SELECT SeekNo-1 into serialNo From Seek where Year=YEAR(CURRENT_DATE());
SELECT serialNo;
END
你是要改逻辑需求呢?
还是单单帮你修改语句中的语法错误呢?(我上面只仅帮你修改了你的语法错误)
请把问题说清楚点 或hi我详说
本文如未解决您的问题请添加抖音号:51dongshi(抖音搜索懂视),直接咨询即可。