Current AUTO_INCREMENT value for any table

Get the current auto_increment value for any table in Mysql Output (example) Name: TableName Engine: InnoDB Version: 10 Row_format: Compact Rows: 599470 Avg_row_length: 170 Data_length: 102367232 Max_data_length: 0 Index_length: 110100480 Data_free: 274726912 Auto_increment: 578752 Create_time: 2015-12-10 17:02:37 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: