not null primary key)
-Original Message-
From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 13, 2005 7:33 PM
To: MySQL
Subject: Re: Help with a tricky/impossible query...
I should mention that I'm constrained to version 4.0.n so no sub queries for
me!
An
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 ra
om: Paul B van den Berg [mailto:[EMAIL PROTECTED]
Sent: Thu 14 April 2005 10:47
To: MySQL
Cc: Andrew Braithwaite
Subject: Help with a tricky/impossible query...
Hi,
In SQL you need to define the data that you want to work with:
create table z ( z int(5) not null primary key); insert into z values
Hi,
In SQL you need to define the data that you want to work with:
create table z ( z int(5) not null primary key);
insert into z values
(1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),(15),(16),(17),(18),(19),(20),(21),(22);
If you need more values you could use a simple perl loo
I should mention that I'm constrained to version 4.0.n so no sub queries for
me!
Andrew
On 14/4/05 1:11 am, "Andrew Braithwaite" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I need some help with a tricky query. Before anyone asks, I cannot bring
> this functionality back to the application layer (as
Hi,
I need some help with a tricky query. Before anyone asks, I cannot bring
this functionality back to the application layer (as much as I'd like to).
Here's what I need to do...
create table wibble(
seq int(3) auto_increment primary key,
x int(5),
y int(5)
);
insert into wibble set x=5, y=10
