Jump to content

Archived

This topic is now archived and is closed to further replies.

nassar

Atu Increment Field Problem

Recommended Posts

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

 

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.