On Tue, Nov 26, 2013 at 2:48 PM, Joey Quinn <bjquinn...@gmail.com> wrote:
> The ranges are indeed overlapping, though the update statements were > generated alphabetically rather than in IP order... If the command line > will let me query the table directly without being blocked by the ongoing > updates, then I could get a rough order of magnitude of progress by doing a > null count on the county field... hate to throw queries at it while it's > busy updating though... > Try a SELECT ... LIMIT 1; it will find the first row that matches and exit. So you can see if any particular country code has been set. Again, binary search on the codes.
