On Thu, 14 Apr 2005 11:57:50 +0100
"Andrew Braithwaite" <[EMAIL PROTECTED]> wrote:
> Thanks for the idea,
>
> Unfortunately I can't do that as the ranges involved are unknown and
> will be from 1 to several billion at lease. I can't have another table
> that needs to be augmented each time my ranges change.
>
> Any other ideas?
>
> Cheers,
>
> Andrew
I Think you really need the second table, but you can fill it as needed:
my $x=1700;
my $y=2200;
$dbh->do( q{ insert into wibble set x=$x, y=$y });
for ($i=$x; $i <=$y ; $i++) {
$dbh->do( q{ insert ignore into z set z = $i });
}
Regards, Paul
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
