mysql数据库中的自增字段会不会溢出，我用的是int，万一超过这个int的表示范围会怎样
最新回答
霓裳梦颜
2026-07-08 03:37:11
仙味萝莉
2026-07-16 12:43:54
orcale:
select a.vseq,a.declaredate as declaredate1,b.declaredate as declaredate2
from
(select vseq,declaredate,rownum as row from mac505 order by vseq,declaredate)a,
(select vseq,declaredate,rownum as row from mac505 order by vseq,declaredate)b
where a.vseq=b.vseq and a.row+1=b.row and a.declaredate+1000<b.declaredate
sql server由于只有2005以上版本才有row_number()函数，所以如下脚本只能用在2005以上版本中
select a.vseq,a.declaredate as declaredate1,b.declaredate as declaredate2
from
(select vseq,declaredate,row_number() orver (order by vseq,declaredate) as row from mac505 )a,
(select vseq,declaredate,row_number() orver (order by vseq,declaredate) as row from mac505 )b
where a.vseq=b.vseq and a.row+1=b.row and a.declaredate+1000<b.declaredate
选择奔跑
2026-04-08 11:50:15
言笑往事
2026-06-22 14:59:02
热门标签
