From: Date: May 3 2005 1:04am
Subject: Re: newbie: delete row xy
List-Archive: http://lists.mysql.com/mysql/183530
Message-Id: <40a16b36050502160472926393@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

> I want to delete e.g  row 1433=20

There is NO row "1433"!
"1433"  would depend upon which column(s) specified in ORDER BY clause.
A table is a collection and a collection has NO inherent order.

On 5/2/05, Christoph Lehmann <christoph.lehmann@stripped> wrote:
> Hi
> I now how to use delete together with a WHERE statement. But e.g. after
> some warnings revealed me certain rows being inconsisent, and I want to
> delete them- how can I do this? I just know that I want to delete e.g
> row 1433 (I have no special id)
>=20
> thanks for a hint
>=20
> cheers
> christoph
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=3Dsol.beach@stripped=
om
>=20
>