mysql获取指定表当前自增id值

SELECT `AUTO_INCREMENT`
FROM  INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'database'
AND   TABLE_NAME   = 'log';