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: