RE: [PHP] MySQL queston - Which row does it put your info into?

[Rick Emery]

When records are deleted, the space they occupied are marked as vacant.  New
records are inserted into those locations.

That said, since this is a relational database, it really doen't matter
where the new records are inserted.

If you want the nitty-gitty details of MYSQL or help, go to the the
[EMAIL PROTECTED] mailing list

-Original Message-
From: Phil Schwarzmann [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 24, 2002 1:15 PM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL queston - Which row does it put your info into?


When Im adding rows into my MySQL database using PHP, it seems to put
them in random places in the database.  Sometimes at the beginning,
sometimes at the end, sometimes in the middle of the database.  
 
Why is it doing this?
 
Thanks for your help!!

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP] MySQL queston - Which row does it put your info into?

[Rasmus Lerdorf]

That's how databases work.  There is no implied ordering internally.  An
order is only applied if you add an order by clause on a select.

-Rasmus

On Thu, 24 Jan 2002, Phil Schwarzmann wrote:

 When Im adding rows into my MySQL database using PHP, it seems to put
 them in random places in the database.  Sometimes at the beginning,
 sometimes at the end, sometimes in the middle of the database.

 Why is it doing this?

 Thanks for your help!!



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]