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]