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:
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--