如何逐个选择记录而不重复 [英] How to select records one by one without repeating

问题描述

select id, name from customer order by random() limit 5;

上述查询选择随机记录。但是它重复行。我只想选择一行，每次不重复。说我有id 1到5.对于第一次我想选择1，第二次查询显示2，然后3,4&一旦序列完成，它再次开始1。

The above query select random records. However it repeats rows. I just want to select a single row each time without repeating. Say i have id 1 to 5. For first time i want to select 1, second time the query displays 2 then 3,4 & 5. Once the sequence is completed it starts again with 1.

推荐答案

$query= "select id, name from customer order by id limit ".rand(1,5).",1"

有关使用limit的详情，请参阅： http：// dev。 mysql.com/doc/refman/5.0/en/select.html

Read more about using limit here: http://dev.mysql.com/doc/refman/5.0/en/select.html

这篇关于如何逐个选择记录而不重复的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！