MySQL: View table status and Edit auto-increment

SHOW TABLE STATUS LIKE "[table_name]"
ALTER TABLE [table_name] AUTO_INCREMENT = 100;