MySQL: View table status and Edit auto-increment
SHOW TABLE STATUS LIKE "[table_name]"
ALTER TABLE [table_name] AUTO_INCREMENT = 100;


References:
     12.4.5.38. SHOW TABLE STATUS Syntax
     3.6.9. Using AUTO_INCREMENT