Apache Friends Support Forum

Please, I'm using XAMPP 1.8.3 (Windows), and when I run the command

Code: Select all

ALTER TABLE  `users` AUTO_INCREMENT =2;

in MySQL through phpMyAdmin, it shows run successfully but does not execute the command. Why?
Thank you!

ifiult wrote:it shows run successfully but does not execute the command.

How do you check it is not executed?

Please, follow to reproduce the problem:

phpMyAdmin (XAMPP 1.8.3 Windows)

1 - Insert some data in row 1, 2 and 3 (all with "id" column AUTO_INCREMENT)
2 - Delete the row 3
3 - Click on the "Operations" tab and change table options "AUTO_INCREMENT = 4" to "AUTO_INCREMENT = 3" then click "Go". Wait for the message: "Your SQL query has been executed successfully".
4 - Click on the "Browse" tab, and click again to the "Operations" tab.

See that the change was not saved in AUTO_INCREMENT.

Yeah, i see.
That is because auto_increments in INNODB are handled different than these from MyISAM (where decreasing the auto_increment with this command is still working).
So it's an INNODB limitation.

Thank you very much!