xxxxxxxxxx
ALTER TABLE your_table_name AUTO_INCREMENT = new_start_value;
xxxxxxxxxx
SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'database_name' AND TABLE_NAME = 'table_name';
xxxxxxxxxx
ALTER TABLE document MODIFY COLUMN document_id INT auto_increment
xxxxxxxxxx
#reiniciamos el auto-incrementable
ALTER TABLE nombre_tabla AUTO_INCREMENT = 1;
xxxxxxxxxx
ALTER TABLE `table_name` ADD COLUMN `id` INT AUTO_INCREMENT UNIQUE FIRST;