MySQL 的存储过程哪里写错了？

Question

CREATE DEFINER = 'root'@'%'
PROCEDURE a.system_getnewid(out RetId INT)
BEGIN
  DECLARE @MinId INT default 1000000000;
  SELECT @RetId =ISNULL(MIN(ISNULL(ID,@MinInt))+1,@MinInt) FROM system_newid;

 IF @RetId=@MinInt 
     INSERT system_newid (ID) VALUES (@MinInt)

  UPDATE system_newid SET ID=@RetId
END

查了相关文档，对语法不是很熟悉，请指正。

Answer 1

CREATE DEFINER = 'root'@'%'
PROCEDURE a.system_getnewid()
BEGIN
  UPDATE system_newid SET ID = ID + 1;
  SELECT ID FROM system_newid;

END

放弃治疗了……