摘要: @i声明变量;id自增长,由于删除而id不连续,查询缺失id (id范围1至65535) SELECT id-1 FROM ( SELECT (@i:=@i+1) i, t1.id FROM test_table t1,(select @i:=0) it WHERE cast(t1.id as DE 阅读全文
posted @ 2021-05-19 10:15 是谁扭曲了时空 阅读(408) 评论(0) 推荐(0) 编辑