Go to Topic: Previous•Next
Go to: Forum List•Message List•New Topic•Search•Log In•Print View
Auto increment Problem
Posted by: ansh_soni143 (---.253.173.122.airtelbroadband.in)
Date: July 17, 2013 07:54AM

Auto increment in Operations is not working properly
When i set Auto increment to 1 from any value after deleting all records from the table it remains the same



Edited 1 time(s). Last edit at 07/17/2013 10:15AM by ansh_soni143.

Options: Reply•Quote
Re: Auto increment Problem
Posted by: stevenmartin99 (Moderator)
Date: July 17, 2013 08:03AM

Why 0?

It's default is 1 as it is "next value"

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: Reply•Quote
Re: Auto increment Problem
Posted by: ansh_soni143 (112.196.20.---)
Date: July 17, 2013 10:27AM

i mean when i change the Auto increment value to 1 after deleting all the records i will retain the old value

Options: Reply•Quote
Re: Auto increment Problem
Posted by: RiggsFolly (---.as13285.net)
Date: July 17, 2013 10:52AM

Hwo are you resetting the auto_increment back to 1?

Options: Reply•Quote
Re: Auto increment Problem
Posted by: ansh_soni143 (112.196.20.---)
Date: July 17, 2013 10:54AM

From OPERATIONS

AUTO_INCREMENT =1

Options: Reply•Quote
Re: Auto increment Problem
Posted by: RiggsFolly (---.as13285.net)
Date: July 17, 2013 11:23AM

Try using the 'Empty table (TRUNCATE)' link, bottom right of the Operations page.
That resets the auto increment automatically.


However even if I run a query to delete all the rows and then manually set the autoincrement to 1 it works for me as expected.

What database type are you using MYISAM or INNODB?

Options: Reply•Quote
Re: Auto increment Problem
Posted by: ansh_soni143 (---.253.173.122.airtelbroadband.in)
Date: July 17, 2013 11:26AM

This problem is coming in wamp2.4

Options: Reply•Quote


Go to: Forum List•Message List•Search•Log In
Sorry, only registered users may post in this forum.
Click here to login