Why does mysql keep inserting data in random places and how can I fix this?

[satokenta]

I am using mysql 5.0.51a with php 5.2.5

I am using the insert command to enter data.

It keeps inserting data in random locations in the table, which is messing up my web app.

It did use an id column at one time.

I’ve tried flushing the table, and remaking the table with phpmyadmin’s sql dump.

How can I fix this? I just want mysql to insert data at the end of the table, like it should.

<snip>

[Dan_Grossman]

There is no intrinsic ordering to the data. None of the default storage engines guarantee data will be stored in insertion order. You have to order by some column if you want it sorted.

[r937]

@satokenta

It keeps inserting data in random locations in the table, which is messing up my web app.

fix your web app, because the database is behaving exactly as it should