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
Something like that anyway.
From: Baron Schwartz [mailto:baron@stripped]
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"
> 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/mysql?unsub=1