RE: How can I delete a block of random rows?

> -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

RE: How can I delete a block of random rows?

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

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 "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

How can I delete a block of random rows?

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. ÐÆ5ÏÐ