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. Something like that anyway. -----Original Message----- 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 "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? 1%? DELETE FROM TABLE WHERE RAND() < .01; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
