> -Original Message-
> From: Baron Schwartz [mailto:[EMAIL PROTECTED]
> Sent: Saturday, 4 August 2007 12:41 PM
> Subject: Re: How can I delete a block of random rows?
>
> Daevid Vincent wrote:
> > I have a SQL dump that I load in for testing with lots of
ssage-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: Saturday, 4 August 2007 12:41 PM
To: Daevid Vincent
Cc: 'MySQL General'
Subject: Re: How can I delete a block of random rows?
Daevid Vincent wrote:
> I have a SQL dump that I load in for testing with lots of "interestin
Daevid Vincent wrote:
I have a SQL dump that I load in for testing with lots of "interesting"
data.
I want to now pair that down to a smaller subset, however I can't just
delete from a range of ID's, as the data is sequential.
I want to delete say 1000 random rows from the table.
What frac
