Re: MySql:delete

2001-06-22 Thread Benjamin Pflugmann
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 B

RE: MySql:delete

2001-06-22 Thread Don Read
On 22-Jun-01 Martin Quevedo 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??? > There is no 'end' (or 'begin' for that matter) to a

Re: MySql:delete

2001-06-22 Thread VVM Ravikumar Sarma Chengalvala
Auto_increment is one of the options --Ravi --- Martin Quevedo <[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??

MySql:delete

2001-06-22 Thread Martin Quevedo
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??? Martin - Before posting, please