早上好!
我正试着做一些应该相当简单的事情,但我还没能找到一个有效的答案。我试图从表中拉下条目0-999,然后1000- 1999,2000 -2999等。这是我目前得到的,但它仍然向下拉0-999+,因为它增加
for($k = 0; $k < 10000; $k += 1000)
{
$query = "select * from TABLENAME LIMIT 1000 OFFSET " . $k;
.....
}
试试这个:
for($k = 0; $k < 10000; $k += 1000)
{
$query = "select * from TABLENAME LIMIT {$k},1000";
.....
}
$start = 0;
$end = 0;
for($k = 0; $k < 10000; $k += 1000)
{
$flag = $start+999;
$end = 1000;
$query = "select * from TABLENAME LIMIT $start,$end";
.....
$start = $flag+1;
}