> -----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 > "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 fraction of the rows do you want to delete? 10%? > > DELETE FROM TABLE WHERE RAND() < .10;
Thanks! That works awesome. > -----Original Message----- > From: Andrew Armstrong [mailto:[EMAIL PROTECTED] > Sent: Friday, August 03, 2007 9:18 PM > Subject: RE: How can I delete a block of random rows? > > Are you sure you want to delete random rows, or do you (if you have > sequential IDs) just want to delete every n'th row? > > DELETE FROM table WHERE id MOD 5 = 0 > > Delete every 5th row from the table assuming sequential IDs > with no missing numbers. I like this idea too, however after a certain point, it stops deleting. :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]