表:pageinfo
字段:IDSELECT
(CASE WHEN EXISTS(SELECT * FROM pageinfo b WHERE b.ID = 1)
THEN MIN(ID) + 1 ELSE 1 END) as HandleID
FROM pageinfo
WHERE NOT ID IN (SELECT a.ID - 1 FROM pageinfo a)
字段:IDSELECT
(CASE WHEN EXISTS(SELECT * FROM pageinfo b WHERE b.ID = 1)
THEN MIN(ID) + 1 ELSE 1 END) as HandleID
FROM pageinfo
WHERE NOT ID IN (SELECT a.ID - 1 FROM pageinfo a)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货