> I want to delete e.g row 1433 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 <[EMAIL PROTECTED]> 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) > > thanks for a hint > > cheers > christoph > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]