Hi.
In a relational database you may _not_ rely on internal order. It is
completely up to the RDBMS how it handles insertions. The internal
order is "undefined" by definition according to the SQL standard.
Therefore you should have no interest at all on where insert go to.
Use SELECT ... ORDER BY to retrieve rows in a certain order.
Bye,
Benjamin.
On Fri, Jun 22, 2001 at 04:14:07PM +0000, [EMAIL PROTECTED] wrote:
> Hi all,
>
> When I perform a delete command and then I insert a new row, this new
> row is placed in the row just deleted. Is it possible to place newly
> inserted rows always at the end of the 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