View table details in MySQL

show table status like 'yourtablename';

Will display info on row_count, auto_increment value, etc. Handy.