zii/id_series.sql

## id_series.sql
# 查询缺失的主键ID
set @a := 0;
select t.r0, t.r1 from
(
 select id, @a+1 as r0, id-1 as r1, if(id>@a+1, 0, 1) as 'series', @a:=id as 'a' from test
 order by id
) t
where t.series=0
order by t.id
;
	# 查询缺失的主键ID
	set @a := 0;
	select t.r0, t.r1 from
	(
	select id, @a+1 as r0, id-1 as r1, if(id>@a+1, 0, 1) as 'series', @a:=id as 'a' from test
	order by id
	) t
	where t.series=0
	order by t.id
	;