Gossamer Forum
Home : General : Databases and SQL :

MySQL Issue

Quote Reply
MySQL Issue
MySQL PROBLEM

For some strange reason, my autoindex has the value of 2,147,483,647, even though I only have 20 entries and every previous autoindex was from 1-22, in my table. Seems buggy cause when I INSERT an item into the table, the autoindex again remains to be that same number rather then auto_incrementing which it is set up to do.

Anyone else had this problem before?
Quote Reply
Re: [JoFrRi] MySQL Issue In reply to
Strange...
You can set down your index using
Code:
ALTER TABLE tablename AUTO_INCREMENT = whatever;
Quote Reply
Re: [mkp] MySQL Issue In reply to
Thank you, Much appreciated. Smile