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

Discussion in 'Server Operation' started by Mellvin, Jan 31, 2011.

  1. Mellvin

    Mellvin New Member

    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.
  2. falko

    falko Super Moderator ISPConfig Developer

    Can you post the CREATE TABLE statement that you used to create the table?

    I guess that it's just phpMyAdmin not showing the records in the right order. You can sort the records by their ID in phpMyAdmin.

Share This Page