mahoune
Guest
Переполнение AUTO_INCREMENT
Ethan Pooley: The solution presented here, ALTER TABLE tbl_name AUTO_INCREMENT = 1, only seems to work for me when the table is empty. I have found other suggestions in other forums, but have not found one that will reset the auto_increment number on a populated table. This would be very useful for making columns such as session_ids wrap without having to drop and recreate them, or without having to use BIGINT to try and avoid running out of ids. Having an upper limit to your auto_increment column could create the possibility of DOS attacks in some applications.
Это здесь взято!
MySQL Manual : AUTO_INCREMENT
А что All думает по этому поводу?
Ethan Pooley: The solution presented here, ALTER TABLE tbl_name AUTO_INCREMENT = 1, only seems to work for me when the table is empty. I have found other suggestions in other forums, but have not found one that will reset the auto_increment number on a populated table. This would be very useful for making columns such as session_ids wrap without having to drop and recreate them, or without having to use BIGINT to try and avoid running out of ids. Having an upper limit to your auto_increment column could create the possibility of DOS attacks in some applications.
Это здесь взято!
MySQL Manual : AUTO_INCREMENT
А что All думает по этому поводу?
