1.进入mysql/bin目录下输入mysqladmin processlist
2.启动mysql,输入show processlist
如果ID是主键或者有索引,可以直接查找:
方法一,查询上一条记录的SQL语句(如果有其他的查询条件记得加上other_conditions以免出现不必要的错误):1select * from table_a where id = (select id from table_a where id < {$id} [and other_conditions] order by id desc limit 1) [and other_conditions]查询下一条记录的SQL语句(如果有其他的查询条件记得加上other_conditions以免出现不必要的错误):1select * from table_a where id = (select id from table_a where id > {$id} [and other_conditions] order by id asc limit 1) [and other_conditions]
方法二,查询上一条记录的SQL语句((如果有其他的查询条件记得加上other_conditions以免出现不必要的错误))1select * from table_a where id = (select <a href="http://www.baidu.com/swd=max&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1d9PjIP1Rvuy7hn1NBrAuW0ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6K1TL0qnfK1TL0z5HD0IgF_5y9YIZ0lQzqlpAbmyt8mh7GuZR8mvqVQL7dugPYpyq8Q1csnHDkrj6srj04rj64PH0LPj6" target="_blank" class="baidu-highlight">max</a>(id) from table_a where id < {$id} [and other_conditions]) [and other_conditions]
查询下一条记录的SQL语句(如果有其他的查询条件记得加上other_conditions以免出现不必要的错误):1select * from table_a where id = (select min(id) from table_a where id > {$id} [and other_conditions]) [and other_conditions]。
您好,很高兴为您解答。
方法一:
查询上一条记录的SQL语句(如果有其他的查询条件记得加上other_conditions以免出现不必要的错误):
select * from table_a where id = (select id from table_a where id < {$id} [and other_conditions] order by id desc limit 1) [and other_conditions]查询下一条记录的SQL语句(如果有其他的查询条件记得加上other_conditions以免出现不必要的错误):
select * from table_a where id = (select id from table_a where id > {$id} [and other_conditions] order by id asc limit 1) [and other_conditions]方法二:
查询上一条记录的SQL语句((如果有其他的查询条件记得加上other_conditions以免出现不必要的错误))
select * from table_a where id = (select max(id) from table_a where id < {$id} [and other_conditions]) [and other_conditions]查询下一条记录的SQL语句(如果有其他的查询条件记得加上other_conditions以免出现不必要的错误):
select * from table_a where id = (select min(id) from table_a where id > {$id} [and other_conditions]) [and other_conditions]如若满意,请点击右侧【采纳答案】,如若还有问题,请点击【追问】
希望我的回答对您有所帮助,望采纳!
~ O(∩_∩)O~
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)