Just to complete...
If your table has a sequence as primary key (auto_increment column), you can
delete the first row inserted based on the initial value of your sequence.
However this is relevant to the application business.
SQL, as mentioned before, has no concept like "first in a table".
You can always look for the smallest value for the primary key and delete it
if this is the case.
Siomara
>From: Benjamin Pflugmann <[EMAIL PROTECTED]>
>To: Lucio Braga <[EMAIL PROTECTED]>
>CC: lista mysql <[EMAIL PROTECTED]>
>Subject: Re: How delete the first register in a table?
>Date: Thu, 5 Jul 2001 23:20:53 +0200
>
>Hi.
>
>Within SQL, there is no such concept like "first in a table". By
>specification the internal table order is undefined and completely
>open to the actual implementation and may change anytime without
>notice. You may not rely on it.
>
>Order is determined on retrieval (SELECT) with the ORDER BY clause.
>
>If you want to preserve the original insertion order, you should have
>an auto_increment column which keeps an appropriate id.
>
>Bye,
>
> Benjamin.
>
>
>On Wed, Jul 04, 2001 at 12:17:50AM -0300, [EMAIL PROTECTED] wrote:
> > How can i do to delete the first row, tuple, register of a table?
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
