mysql>showtablestatuslike'stu'\g;+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+--------------...
mysql> show table status like 'stu'\g;
+------+--------+---------+------------+------+----------------+-------------+--
---------------+--------------+-----------+----------------+--------------------
-+-------------+------------+-----------------+----------+----------------+-----
----+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | M
ax_data_length | Index_length | Data_free | Auto_increment | Create_time
| Update_time | Check_time | Collation | Checksum | Create_options | Comm
ent |
+------+--------+---------+------------+------+----------------+-------------+--
---------------+--------------+-----------+----------------+--------------------
-+-------------+------------+-----------------+----------+----------------+-----
----+
| stu | InnoDB | 10 | Compact | 8 | 2048 | 16384 |
0 | 0 | 0 | NULL | 2015-08-10 14:28:29
| NULL | NULL | utf8_general_ci | NULL | |
|
展开