OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
How can I delete a block of random rows?

From: Daevid Vincent (daeviddaevid.com)
Date: Fri Aug 03 2007 - 19:45:35 CDT

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