Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 31st January 2011, 05:39
Mellvin Mellvin is offline
Junior Member
 
Join Date: Jan 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Why does mysql keep inserting data in random places and how can I fix this?

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.
__________________
Force Factor
Reply With Quote
Sponsored Links
  #2  
Old 1st February 2011, 14:45
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
 
Default

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.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +2. The time now is 04:25.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.