$count = db($this->table_store, $this->connection)
->count();
$page = 1;
$pageSize = 100;
$totalPage = ceil($count / $pageSize);
$id = 0;

for ($i = 1; $i <= $totalPage; $i++) {
$output->writeln('处理第' . ($i) . '页数据---' . date("Y-m-d H:i:s", time()) . '<br>');

$list = db($this->table_store, $this->connection)
->field('id,*')
->where('id > ' . $id)
->order('id asc')
->page($page, $pageSize)
->select();


$id = $list[count($list) - 1]['id'];
}

发表回复

您的电子邮箱地址不会被公开。 必填项已用 * 标注