Jump to content


Photo

Atu Increment Field Problem


  • Please log in to reply
No replies to this topic

#1 nassar

nassar
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 08 November 2005 - 06:56 PM

Hello Sir Alayham

I've problem in MySQL Database; I hope you can help me to solve it.

Surely this not included in our official agreement with ILLAFTrain Support, But

i send you as Friends



Introduction:

In my database I've 'CLIENTS' table contain my client's information's, the table have auto increment field, it is the ID field.

The table contains now 6540 entry.



Table type MyISAM

ID field type is INT(30) it was 5 and I modify it to 30 I think I can solve problem by doing this but no way.. no solveā€¦





Problem:

Now when we add new client the ID field value become automatically 2147483647, and if we try to add again new clients the ID value become same number so we can Duplicate Error



I try to set the AUTO_INCREMENT value to 6541 but didn't changed and keep old value.



Would you please help me to solve this problem?



Regards
Nassar





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users