MySQL Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Databases > MySQL Help
Reload this Page

auto_increment +153

Discuss auto_increment +153 in the MySQL Help forum on Dev Shed.
auto_increment +153 MySQL Help forum discussing administration, SQL syntax, and other MySQL-related topics. MySQL is an open-source relational database management system (RDBMS).

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old October 7th, 2000, 12:05 PM
girish_gupta girish_gupta is offline
Member
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jul 2000
Location: England, UK
Posts: 83 girish_gupta User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 9
I am using PHPMyAdmin. I have a table with a column called id, this is INT(11) and is auto_increment.

It goes up to 153 then when I add another row it seems to want to go up to 6******!

Does anyone know why?

How do I sort it?

------------------
Girish Gupta
MusicGoesOn.com
Reply With Quote
  #2  
Old October 8th, 2000, 01:14 PM
thedude thedude is offline
The Dude Abides
Dev Shed Beginner (1000 - 1499 posts)
  
Join Date: Feb 2000
Location: grass valley,ca
Posts: 1,063 thedude User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 Day 9 h 4 m 29 sec
Reputation Power: 10
Which version of Phpmyadmin and MySQL?

Try checking the phpmyadmin changelog for related bugs, as well as the MySQL docs. Don't eliminate your server either. I've seen errors caused by different server configs as well

chris
Reply With Quote
  #3  
Old October 8th, 2000, 02:47 PM
girish_gupta girish_gupta is offline
Member
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jul 2000
Location: England, UK
Posts: 83 girish_gupta User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 9
I'm using MySQL 3.23.21-beta-log and phpMyAdmin 2.0.1

I can't find anything in the mySQL docs, where would I find the phpMyAdmin changelog?

Thanks

------------------
Girish Gupta
MusicGoesOn.com
Reply With Quote
  #4  
Old October 9th, 2000, 05:49 PM
thedude thedude is offline
The Dude Abides
Dev Shed Beginner (1000 - 1499 posts)
  
Join Date: Feb 2000
Location: grass valley,ca
Posts: 1,063 thedude User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 Day 9 h 4 m 29 sec
Reputation Power: 10
The change log is on the phpmyadmin site phpwizard.net.

Are you uploading a text file database or are you creating it using phpmyadmin? Upload errors are very common. I've seen some really wild errors from doing the load data (local?) infile command.

I would also suggest contacting your hosting provider.

good luck
chris
Reply With Quote
Reply

Viewing: Dev Shed Forums > Databases > MySQL Help > auto_increment +153

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway. 
Stay green...Green IT