sqlserver批次获取部分数据python实现

# 设置每次获取数据的批量大小
        batch_size = 2000
        sql="SELECT DISTINCT * FROM {} ORDER BY OBJECTID LIMIT %s OFFSET %s".format(
            tablename)
        offset = 0
        while True:
            sql=sql % (batch_size,offset)
            data_mysqls = Mysqlbaidupoi.query(sql)
            # 如果结果集为空，则退出循环
            if not data_mysqls:
                break
            # 更新偏移量
            offset += batch_size