Results 1 to 3 of 3
Thread: auto_increment can't count
Feb 24, 2001, 11:07 #1
I have a table and user_id is on auto_increment.
it first field is 1 and then the next one it sets to 2147483647. how come this isin't 2?
This is from phpmyadmin
type Null Extra
user_id int(10) No auto_increment
the scirpt that creates this works fine on localhost just does this on the server mechine which is running mysql 3.23Garlic bread, I've tasted it, it's the future
Feb 24, 2001, 12:21 #2
I followed the backing up article on sitepoint and backed up my working copy on localhost and then put this onto the server yet the server one still doesn't work, which is a backup of the one on my localhost that does work.
localhost is running 3.22.34. is there some problem with the version the server is running?Garlic bread, I've tasted it, it's the future
Feb 24, 2001, 13:30 #3
- Join Date
- Dec 2000
- Idaho, USA
- 0 Post(s)
- 0 Thread(s)
EMPTY your table... then use PHP to add something.. and let it count itself.. from one on. Don't enter anything for the auto-increment... let it do that automaticly. I had similiar problems.. and I had to DUMP my table, and reconstruct it.Blamestorming: Sitting around in a group discussing why a deadline was missed or a project failed and who was responsible.
Exbabylon- Professional Internet Services