Mysql : Get Auto increment value

SELECT AUTO_INCREMENT FROM information_schema.tables
WHERE table_name = 'club_photogallery'