mysql查看某一条记录在数据库中是第几条
操作数据的时候,中间需要断开一次,但表中数据id是不连续的 ,为了下次运行从所断掉的id处开始,所以记录断开时的id:416641,查看这条数据在数据库表中是第几条:SELECT count(*)from (SELECT * FROM fortress.x_media_assets_publish ORDER BY id) as awhere id >= (SELECT id ...
·
操作数据的时候,中间需要断开一次,但表中数据id是不连续的 ,为了下次运行从所断掉的id处开始,所以记录断开时的id:416641,查看这条数据在数据库表中是第几条:
SELECT count(*) from (SELECT * FROM fortress.x_media_assets_publish ORDER BY id) as a
where id >= (SELECT id from fortress.x_media_assets_publish where id = '416641')
得到在数据库的条数:158015;然后再查询从这条开始向后的数据:
SELECT * FROM fortress.x_media_assets_publish limit 158015,999999999
更多推荐
所有评论(0)