MySQL Get table information

MySQL Get table information

mysql> use Test;database changedmysql> Show Table status;+---------------+--------+---------+------------+---- --+----------------+-------------+-----------------+--------------+-----------+----------------+--------------- ------+-------------+------------+-----------------+----------+----------------+---------+| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | create_options | Comment |+---------------+--------+---------+------------+------+----------------+-------------+---------------- -+--------------+-----------+----------------+---------------------+-------------+------------+---------------- -+----------+----------------+---------+| EMP |      InnoDB | 10 |    Compact |              0 |               0 |16384 |            0 |         0 |           0 | NULL | 2015-09-16 16:18:06 |      Null  | NULL |     Utf8_general_ci |   NULL |         | || Stu_view |    NULL | NULL | NULL |           NULL | NULL |            NULL |         NULL |      NULL |           NULL | NULL | NULL | NULL | NULL |     NULL | NULL | NULL | VIEW | | T_depart_info |      InnoDB | 10 |    Compact |              0 |               0 |16384 |            0 |         0 |           0 | NULL | 2015-08-23 22:12:02 | NULL | NULL |     Utf8_general_ci |   NULL |         | || T_stu_info |      InnoDB | 10 |    Compact |           6 |               2730 |16384 |            0 |         0 |              0 | 9 | 2015-08-23 21:36:02 | NULL | NULL |     Utf8_general_ci |   NULL |         | || T_tea_info |      InnoDB | 10 |    Compact |              0 |               0 |16384 |        0 |         16384 |              0 | 1 | 2015-08-23 21:39:53 | NULL | NULL |     Utf8_general_ci |   NULL |         | |+---------------+--------+---------+------------+------+----------------+-------------+-----------------+------------ --+-----------+----------------+---------------------+-------------+------------+-----------------+----------+- ---------------+---------+5 rows in Set (0.00 sec) mysql>

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

MySQL Get table information