From: Daevid Vincent
Date: August 4 2007 12:45am
Subject: How can I delete a block of random rows?
List-Archive: http://lists.mysql.com/mysql/208419
Message-Id: <BRAKAneeFUtLch9wPiy000002ea@mx1.lockdownnetworks.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_004C_01C7D5F6.18BA4480"

------=_NextPart_000_004C_01C7D5F6.18BA4480
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I have a SQL dump that I load in for testing with lots of "interesting"
data.
=20
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.
=20
I want to delete say 1000 random rows from the table.
=20

=D0=C65=CF=D0=20

=20

------=_NextPart_000_004C_01C7D5F6.18BA4480--