MySQL: Auto Increment

SELECT AUTO_INCREMENT
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = "databaseName"
AND TABLE_NAME = "tableName"

alter table tablename auto_increment = newvalue
Luis Romero